Import Macro Access Table to Outlook Contacts

S

srctr

I would like to automate the import of an Access table into a specific folder
in my Outlook Contacts. Can this be done?
 
A

Alan Moseley

Yes it can. You need to use (for example) ADO to connect to your Access
database and get a recordset, then use the Outlook Object Model to create a
new contact and populate its fields.

If this is a one-off exercise you can also use the import wizard in Outlook.
 
S

srctr

What you said is greek to me. I was hoping that importing into Outlook from
access might be easier then using Access to export addresses into Outlook. I
can't seem to find any good and clear explanation on how to do either of
these. ADO, DAO, VBA, Macros - no one seems to speak clear about these
processes for a newbie to gain knowledge to learn to use these. Is there
anyone who can give clear, precise instructions on a way to take email
addresses in Access and automate sending an email message to said addresses,
allowing for me to manually attach needed file (changes every month) and send
message?

It really shouldn't be this big complicated coding secret.
 

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

Linking Outlook to Access for Contacts in Access 3
How to export table from outlook into ms access table? 0
Using Outlook 2007 to import contacts information from Access database 1
Macro to Import 4
Running Import Data from Access 1
Macro to export Outlook contacts 1
Sharing contacts in a workgroup 9
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top