from Access lookup Outlook contact to see if exists

E

Eri

Hello,

Several days ago, I posted a message regarding exporting
an Access 2000 table with contact information to Outlook
2000 contact listing. The gentleman that replied to my
posting showed me how to do that through VBA.
Unfortunately, I was taught to append Access records to
Outlook contact listing regardless if the contact name
already exists in Outlook; resulting in duplicate contact
names.

What I want to know is how to have Access scan the contact
listing in Outlook, compare the entries with the records
in Access and export the record from Access only if the
name does not already exist in outlook.

Someone, please tell me that this is possible!

Any input is greatly appreciated!

Eri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2013: assign new categories to several thousand existing contacts 0
Exporting Access 2007 Date to Outlook 2007 Contacts 0
Outlook 2010 Contacts 0
Automatically importing outlook contacts into access database. 0
Import an outlook contact list into access 2007 0
"Linking" Access 2007 Data with Outlook contacts 1
Append query to Outlook contacts 2
How to use a linked outlook contact folder-table in Access 2007 ? 0

Top