How do I import a Table of e-mail address w/ names into outlook?

[Guest]

I have a contact list in Microsoft Access that contains names and e-mail
addresses and I need to be able to export that information to some sort of
e-mail list that I can use in Microsoft Outlook to send an e-mail to all of
the contacts. This process needs to somewhat automated because people in my
organization with no computer skills will need to be able to perform this
task on their own. Any ideas???

 

[John Nurick]

Hi Fred,

One approach is to have Access generate an email addressed or cc'd to
all the addresses. Another is to have Access create an Outlook Contact
item for each person on the list, after which the user can work with
Outlook in the accustomed way. (Outloook itself can import records from
Access into a Contacts folder.)

These links should help you get started:
OL2000: How to Programmatically Import Outlook Items from Microsoft
Access
http://support.microsoft.com/?id=208232

Using Automation in Microsoft Office Access 2003 to Work with Microsoft
Office Outlook 2003
http://msdn.microsoft.com/library/d...ry/en-us/dno2k3ta/html/odc_ac_olauto.asp?_r=1

Tony Toews's email FAQ at http://www.granite.ab.ca/access/email.htm

For Outlook and Outlook programming generally, see www.slipstick.com and
www.outlookcode.com