View Single Post
  #3  
Old February 23rd 09, 06:26 PM posted to microsoft.public.outlook.program_vba
srctr
external usenet poster
 
Posts: 2
Default Import Macro Access Table to Outlook Contacts

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.

--
cao


"Alan Moseley" wrote:

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.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"srctr" wrote:

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

Ads