E-mail from Access 2000

[bdj]

This discussion group is extremely useful and I wondered if anyone out there had any idea as to how to put an e-mail address list box on a form and have the equivalent of a To:- button that you can select from the contacts list to input the e-mail address to that particular field.

It must be relatively easy but I cannot find out how to do it anywhere. PS I have seen it done in an Outlook template but never in Access

Any help would be appreciated.

Brian Jermain

 

[yippie_ky_yay]

Hey Brian,

Dim strEmail as String
strEmail = lstBox.Column(0)

DoCmd.SendObject , , , strEmail, , , "Here's the subject", "Here's the body", True
(if you don't need to see the email to edit or verify, change the last setting to false).

Hope that helps!

-Sean

 

[Autoeng]

bdj:

Try to keep all of your threads together. If you can't find a previous one you can search on postings by yourself.

As for your problem. You can create a link to the outlook address book and use it to select people to mail. Go to File - Get External Data - Link and then select Outlook as file type, browse to your Outlook address book and there you go.

There is another way also. This method actually calls the Outlook Address book window to select the name, don't have to link to the table.

Here is a thread that is the code behind the db. I'm looking for the sample now and will post when I find it.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=35239&highlight=email

Hope this helps.

Autoeng

 

[Autoeng]

Here is the sample db. Open the form and press the button beside the Address List field. You will probably get an error, select OK, then OK again. The Outlook Address Book should open. Select the names you want, press OK. The rest is self explainatory.

Autoeng