Import Macro Access Table to Outlook Contacts

  • Thread starter Thread starter srctr
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top