emailing from Access

[Guest]

Where an email address is featured on a contacts individual entry (form view)
in access - can you then click on that email and be directed straight to
Outlook to send an email?

 

[Rick B]

This is a very common question. I'd suggest you read the hundreds of
previous posts on the topic. The easiest way I have found is to go to
www.google.com, click the "groups" option, and enter a search string like
the following...

microsoft.public.access email click link

 

[Guest]

Use the sendobject to open the mail box, on the dbl click event of the text
box you can enter the code

Docmd.SendObject acSendNoObject , , ,
Me.MailAddressTextBoxName,,,"Subject","Message"