E-mail from Access 2000

[bdj]

Thanks for the response Sean but perhaps I didn't explain it too well.

What I am trying to do is attach the list box to the Outlook Address book so that I can select the persons e-mail address as an input to the form to be saved in the table.

This will then allow me to do customer surveys on line by just filtering the appropriate records and then sending them out via e-mail.

There is a duplication of effort in having to type in all the e-mail addresses when they are already held in the Outlook Address book.

Any help would be appreciated.

 

[harra]

bdj,

I don't know if this help or even points you in the right direction, but you can link to your Address Book in Outlook.

• In the table view of the Database Window, click on the New Button
• Choose 'Link Table'
• You should get a Dialog Box. In the 'File of Type:' dropdown, choose 'Outlook()'
• The Link Exchange/Outlook Wizard will open. Now you can select what objects of Outlook you'd like to link to. Select the appropriate Address Book

Once the Address Book is linked you can run queries on it just like any other linked table. The only drawback is when you have mutiple e-mails for a single person, it creates a record for each one.

EDITED TO ADD:

Looks like Autoeng already suggested that in this previous thread:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44529