Linking to selected Outlook contacts

  • Thread starter Thread starter Brian Mulawka
  • Start date Start date
B

Brian Mulawka

I'm a middling Access user and have come across what I
consider to be a real stumper.

We have one category of contacts in Outlook that we would
like to use as part of an Access 2002 database. It is
very easy to link to all our contacts and set that up as
a table in access, but is there a way to filter the link
and have Access link only to the contacts in a certain
category?

Any help would be greatly apprecitated!
 
Hi Brian,

I've never done this, but I'd start by creating a View in Outlook that
displayed just the contacts I wanted, and then see if I could somehow
link to that. It's worth searching http://www.slipstick.com for a
solution.

If it's not possible, you can of course link to the entire folder and
then use an Access query to filter the contacts as needed.
 
Hi Simon
Another option in 2002 & 2003 (2000 is a little bit trickier as you will
need to download the actual control from MS) is to use the standard Outlook
dll (the Outlook View Control). You insert the Outlook View Control ActiveX
into a form and all your Outlook folders are there for you to manipulate.
Here is an example:

These are the steps to create a form with the OVC but please note that this
applies only in 2003 as Outlook in 2000 & 2002 has slightly different views
so the code would need to be changed for the Outlook 2000 & 2002 views (i.e.
the code lines that say Me!ctlView.RowSource = ).

1. Create a new form
2. Add a combo box and
- rename it to cboViewType
- Row Source Type is Value List
- Assuming your Outlook installation's default view is Inbox insert as
the Row Source "Messages";"Messages with AutoPreview";"Unread messages in
this folder";"Sent To";"Message Timeline"
3. Add an option group of 6 buttons containing
- an option value of 1 through to 6
- captions of Email, Calendar, Tasks, Contacts, Notes and Sent
- rename the option group to optOutlookView
4. Add the Outlook View ActiveX control and rename it to ctlOutlookView
5. Add the following code to the AfterUpdate property of the combo box
called cboViewType:
Me!ctlOutlookView.View = Me!cboViewType
6. Add the following code to the OnClick property of the option group called
optOutlookView:
Select Case Me!optView
Case 1
Me!OutlookView.Folder = "Inbox"
Me!OutlookView.SetFocus
Me!subHomeDiscussion.Visible = False
Me!ctlView.RowSource = "'Messages';'Messages with AutoPreview';" & _
"'Unread Messages in This Folder';'Sent To';'Message Timeline'"
Me!ctlView = Me!OutlookView.View
Case 2
Me!OutlookView.Folder = "Calendar"
Me!OutlookView.SetFocus
Me!subHomeDiscussion.Visible = False
Me!ctlView.RowSource = "'Day/Week/Month';'Day/Week/Month View " & _
"With AutoPreview';'Active Appointments';'Events';'Annual
Events';" & _
"'Recurring Appointments';'By Category'
Me!ctlView = Me!OutlookView.View
Case 3
Me!OutlookView.Folder = "Tasks"
Me!OutlookView.SetFocus
Me!subHomeDiscussion.Visible = False
Me!ctlView.RowSource = "'Simple List';'Detailed List';'Active
Tasks';'Next Seven " & _
"Days';'Overdue Tasks';'By Category';'Assignment';'By Person
Responsible';" & _
"'Completed Tasks';'Task Timeline'"
Me!ctlView = Me!OutlookView.View
Case 4
Me!OutlookView.Folder = "Contacts"
Me!OutlookView.SetFocus
Me!subHomeDiscussion.Visible = False
Me!ctlView.RowSource = "'Address Cards';'Detailed Address
Cards';'Phone List';" & _
"'By Category';'By Company';'By Location';'By Follow-up Flag'"
Me!ctlView = Me!OutlookView.View
Case 5
Me!OutlookView.Folder = "Notes"
Me!OutlookView.SetFocus
Me!subHomeDiscussion.Visible = False
Me!ctlView.RowSource = "'Icons';'Notes List';'Last Seven Days';'By
Category';'By Color'"
Me!ctlView = Me!OutlookView.View
Case 6
Me!OutlookView.Folder = "Sent Items"
Me!OutlookView.SetFocus
Me!subHomeDiscussion.Visible = False
Me!ctlView.RowSource = "'Messages';'Messages with AutoPreview';" & _
"'Last Seven Days';'Unread Messages in This Folder';'Sent
To';'Message Timeline'"
Me!ctlView = Me!OutlookView.View
Case 7
Me!subHomeDiscussion.Visible = True
Me!subHomeDiscussion.SetFocus
Me!ctlView.RowSource = ""
Me!ctlView = ""
Me!subHomeDiscussion.Requery
End Select

Use the form by selecting one of the main outlook folders by the option
group buttons and then changing the views by selecting one of the views in
the combo box.

Notes:
1. The views have been taken from the standard Outlook views so the views in
the above code would need to be changed when using Outlook 2000 or 2002
4. An example of how we use this control in an application can be found in
our Jackaroo IT application (Access 2000 and 2002) which can be downloaded
from our web site at http://jackaroo.net.au and selecting Use Outlook on the
User Options form.

The control's help file can be downloaded at
http://www.microsoft.com/downloads/...FamilyID=831F957F-3190-48DA-A099-2BDBC7397623

Hope this helps
 
YOU KNOW HOW THE $6.00 WILL GET YOU THOUSANDS STARTS, I found this on
a bulletin
board and decided to try it. WELL, I FIGURED THAT IT WAS A LOAD OF
CRAP, I THOUGHT
THAT WHY ON EARTH AM I GOING TO SEND ANY MONEY TO PEOPLE THAT I
DON'T KNOW.FOR WHAT,
TO BE ON SOMEONE'S MAILING LIST.
COME ON FOR GOODNESS SAKE, I AM A FINANCE MAJOR, I THOUGHT NO WAY. SO
AFTER ABOUT 6
MONTHS OF SEEING THESE LIST APPEAR ON THE CAMPUS FUN BOARD. I DECIDED,
WHAT THE HELL.
I FIGURED WHATS
$6.00. SO AT FIRST, NOTHING ABOUT THE FIRST TWO WEEKS, THEN JUST WHEN
I WAS GETTING
READY TO GIVE MY FRIENDS THE SPEECH ABOUT "SPAM AND WHAT A SCAM" I
PICKED UP MY MAIL,
ON A THURSDAY,
THAT WAS ABOUT ALMOST END OF THE THIRD WEEK I HAD RECIVED $612.00 THAT
THURSDAY.
NOW I AM
IN MY SIXTH
WEEK AND AM AT ALMOST $4,000 DOLLARS. I QUESS NUMBERS DON'T LIE.SO FAR
I HAVE BOUGHT
SOME FURNITURE, GOT MY CAR FIXED, GAVE MY MOM SOME MONEY, AND PAID
SOME ON ONE OF
MY STUDENT LOANS. THE MONEY IS STILL COMMING IN. WHAT A PROFIT, OFF
SUCH A SMALL
INVESTMENT. I KNOW THAT THIER ARE OTHER LISTS OUT THERE. THAT'S
GREAT,BUT WHAT
I WILL SAY IS THAT THE PEOPLE ON THIS LIST HAVE PLAYED FAIRILY AND
HONESTLY, AND WITH INTREGRITY.
IF YOU DO CHOOSE THIS LIST PLEASE PLAY AS FAIR AS OTHERS HAVE.
THE GOOD FORTUNE WILL COME TO YOU IF YOU DO. NOW ONTO THE SHOW....

A while back,I saw this article on a bulltien board it said
that you send $1.00 to each of the 6 names and address stated in the
article.
You then place your own name and address in the bottom of
the list at #6, and post the article in at least 200 newsgroups.
(There are thousands) I
figured: what have I got to lose except 6 stamps and $6.00,
right?
Then I invested the measly $6.00. WELL, GUESS WHAT !!...
within 7 days, I started getting money in the mail! I was shocked! I
figured it would end soon, but the money just kept coming in. In my
first week, I made about $25.00. By the end of the second week I had
made a total of over $1,000.00! In the third week I had over
$10,000.00 and it's still growing. This is now my fourth week and I
have made a total of just over $18,000.00 and it's still coming in
rapidly.
It's certainly worth $6.00, and 6 stamps,
...Also, make sure you print a copy of this
article NOW, so you can get the information off of it as you need it.
I promise you that if you follow the directions exactly, that you
will start making more money than you thought possible by doing
something so easy!
Suggestion: Read this entire message carefully! (print it out or
download it.) Follow the simple directions and watch the money come in!
It's easy. It's legal. And, your investment is only $6.00 (Plus postage)
Follow these directions EXACTLY, and $50,000 or more can be
yours in 20 to 60 days. This program remains successful because of
the honesty and integrity of the participants. Please continue its
success by carefully adhering to the instructions.
You will now become part of the Mail Order business. In this business
your product is not solid and tangible, it's a service, perfectly legal.
You are in
the business of developing Mailing Lists. Many large corporations are
happy to pay big bucks for quality lists. However, the money made
from the mailing lists is secondary to the income which is made from
people like you and me asking to be included in that list.
Here are the 4 easy steps to success:

STEP 1: Get 6 separate pieces of paper and write the following on
each piece of paper; " PLEASE PUT ME ON YOUR MAILING LIST "
and include you name and address

STEP 2: get 6 US $1.00 bills and place ONE inside EACH of the 6 pieces of
paper so the bill will not be seen through the envelope (to prevent
thievery).

STEP 3: place one paper in each of the 6 envelopes and seal
You should now have 6 sealed envelopes, each with a piece of
paper stating the above phrase,PLEASE PUT ME ON YOUR MAILING LIST,
your name and address, and a $1.00 bill.

STEP 4: Mail the 6 envelopes to the addresses below:
What you are doing is creating a service. THIS IS ABSOLUTELY
LEGAL! You are requesting a legitimate service and you are paying for
it! Like most of us I was a little skeptical and a little worried
about the legal aspects of it all. So I checked it out with the U.S.
Post Office (1-800-725-2161) and they confirmed that it is indeed
legal!

#1) Janie Green
133 Holly Hedges Dr.
Florence, MS 39073

#2) Kevin Lee
8377 Apt. #-I Montgomery Run Rd.
Ellicott City, MD 21043

#3) OVERTON
P.O. BOX 18818
SO. LAKE TAHOE, CA 96151

#4) Anthony Palone
P.O. Box 17121
Clearwater, FL. 33762-0121

#5) Rich Trine
P.O. Box 471034
Tulsa, Ok. 74147-1034

#6) B.G.
8150 FISHER ST
WARREN MI, 48089

Now, take the #1 name off the list that you see above, move
the other names up (6 becomes 5, 5 becomes 4, etc...) and add YOUR
Name as number 6 on the list and then start posting this on other groups.

STEP 5: Change anything you need to, but try to keep this article as
close to original as possible. Now, post your amended article to at
least 200 newsgroups. (I think there are close to 24,000 groups) All
you need is 200, but remember, the more you post, the more money you make!

This is perfectly legal! If you have any doubts, refer to Title 18
Sec. 1302 & 1341 of the Postal lottery laws.
Keep a copy of these steps for yourself and, whenever you need money,
you can use it again, and again.
PLEASE REMEMBER that this program remains successful because of the
honesty and integrity of the participants and by their carefully
adhering to the directions.
NOTE: Retain every name and address sent to you,
either on a computer or hard copy and keep the notes people send you.
This VERIFIES that you are truly providing a service. (Also, it might
be a good idea to wrap the $1 bill in dark paper to reduce the risk of
mail theft.)
So, as each post is downloaded and the directions carefully followed,
six members will be reimbursed for their participation as a List
Developer with one dollar each. Your name will move up the list
geometrically so that when your name reaches the #1 position you will
be receiving thousands of dollars in CASH!!! What an opportunity for
only $6.00 ($1.00 for each of the first six people listed above) Send

it now, add your own name to the list and you're in business
---DIRECTIONS ----- FOR HOW TO POST TO NEWSGROUPS------------


You do not need to re-type this entire letter to do your own
posting. Simply put your cursor at the beginning of this letter and
drag your cursor to the bottom of this document, and select 'copy'
from the edit menu. This will copy the entire letter into the
computer's memory.
Step 1) Open a blank 'notepad' file and place your cursor at the top
of the blank page. From the 'edit' menu select 'paste'. This will
paste a copy of the letter into notepad so that you can add your name
to the list.
Step 2) Save your new notepad file as a .txt file. If
you want to do your postings in different settings, you'll always
have this file to go back to.
Step 3) Use Netscape or Internet explorer and try searching for
various newsgroups (on-line forums, message boards, chat sites,
discussions.)
Step 4) Visit these message boards and post this article as a new
message by highlighting the text of this letter and selecting paste
from the edit menu. Fill in the Subject, this will be the header that
everyone sees as they scroll through the list of postings in a
particular group, click the post message button. You're done with
your first one! Congratulations...THAT'S IT! All you have to do is
jump to different newsgroups and post away, after you get the hang of
it, it will take about 30 seconds for each newsgroup!

**REMEMBER, THE MORE NEWSGROUPS YOU POST IN, THE MORE MONEY YOU WILL
MAKE!!
BUT YOU HAVE TO POST A
MINIMUM OF 200**
That's it! You will begin receiving money from around the world within
days!
You may eventually want to rent a P.O.Box due to the large amount of mail
you
will receive. If
you wish to stay anonymous, you can invent a name to use, as long as
the postman will deliver it.
**JUST MAKE SURE ALL THE ADDRESSES ARE CORRECT.**
Now the WHY part:
Out of 200 postings, say you receive only 5 replies (a very low example).
So then I made $5.00 with your name at #6 on the letter. Now,
each of the 5 persons
who just sent you $1.00 make the MINIMUM 200
postings, each with your name at #5 and only 5 persons respond to each
of the original 5, that is another $25.00 for you, now those 25 each
make "200 MINIMUM" posts with your name at #4 and only 5 replies each, I
will bring in an additional $125.00! Now, those 125 persons turn
around and post the "MINIMUM 200" with your name at #3 and only receive 5
replies each, you will make an additional $626.00! OK, now here is the
fun part, each of those 625 persons post a "MINIMUM 200" letters with
your name at #2 and they each only receive 5 replies, that just made you
$3,125.00!!! Those 3,125 persons will all deliver this message to 100
newsgroups with your name at #1 and if still 5 persons per 100
newsgroups react you will receive $15,625,00! With an original
investment of only $6.00! AMAZING! The thing to remember is: do you
realize that thousands of people all over the world are joining the
internet and reading these articles everyday?,THIS WORKS BECAUSE
Estimates are at 20,000 to 50,000
new users, every day, with thousands of those joining the actual internet.
 
Back
Top