Import Macro Access Table to Outlook Contacts
 

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

Import Macro Access Table to Outlook Contacts
 

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

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

Import Macro Access Table to Outlook Contacts
 

Have a look at the following web page, it contains all of the information you
need:-

http://support.microsoft.com/kb/290658

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

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


"srctr" wrote:

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