Start an Outlook e-mail from Access

[Petterq]

I have a database where we have information about our customers and the
contactpersons within each company.

We have a field for the e-mail adresses. Can I create an procedure that
opens a new mail in Outlook when clicking on the e-mail addresse, and if so,
how is it done?

 

[Daniel Pineault]

If all you want to do is start a new e-mail addressed to the selected
recipient the easiest method would be to do something like:

Application.FollowHyperlink "mailto://" & Me.EmailControlName

where EmailControlName is the name of the control on your form that contains
a valid e-mail address to use as the To: field in the e-mail message.

You can also look at http://www.devhut.net/index.php?lang=en&id=0000000013
for automation procedures if you need to do more advanced things such as
populate the message body, add attachments, etc.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.