Link e-mail addresses

K

Ken McLean

Is there anyway I can link a distribution list of e-mail
addresses in Outlook to an Access table or query so that
the distribution list is automatically updated whenever
the database is changed? Thanks for any suggestions.
 
S

Sarita

Ken,

I've been looking to do something similar and to do what you want to do is quite simple. Microsoft already has an article that tells you how to link the two together.

http://office.microsoft.com/assista...ID=HA011165811033&CTT=4&Origin=CH010115981033

If the link doesn't work, here is the article... (You want to link them, not just import)

You can quickly copy or link to your Outlook contacts in an Access database, enabling you to work with your Outlook contacts in an Access database. Your Access data is kept up to date with changes to Outlook contacts, and vice versa, if you choose to link contacts to Access.
1. Open Access and start a new, blank database or open an existing database.
2. Do one of the following:
• On the File menu, point to Get External Data, and then click Import.
• On the File menu, point to Get External Data, and then click Link Tables.
Note If you link Outlook data to Access, any items updated in Outlook are automatically updated in Access.
3. In the Link or Import dialog box, in the Files of Type list, click Outlook. If you have more than one Outlook profile, you are prompted for which profile to use.
4. In the Import Exchange/Outlook Wizard, select the folder or address book that contains the contacts that you want, and then click Next.

Expand the top mailbox folder.
Select the folder that contains the contacts that you want to export.
When you complete the wizard, the Outlook data is placed into an Access table.
5. Follow the instructions on your screen.
 

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

Top