email from a form

[Jerry]

I have a field that holds a person's email address.

Is there a way that if I click that field on a form, a new
blank message form in Outlook will be opened, with the
person's email address in the "To:" field, all set and
ready to go?

 

[Kevin Sprinkel]

There may be more elegant ways of doing it, but I use a
textbox to store the email address, then insert a
Hyperlink Email label onto the form (Insert, Hyperlink).
It will prompt you for an address, and will change the
Hyperlink Address property to "mailto:" plus whatever you
entered. You can change this property dynamically to send
the email to the address stored in your textbox.

- I'll assume your textbox' Name property is
txtEmailAddress

- Change the following properties of the Hyperlink label
control:
- Name to something meaningful like "lblSendEmail"
- Caption to something like "Send Email"

- In the form's On Current Event, change the Hyperlink
Address property to the address stored in your textbox:

Me!lblSendEmail.HyperlinkAddress = "mailto:" _
& Me!txtEmailAddress

To launch the email, just click on the label.

HTH
Kevin Sprinkel

 

[Jerry]

Thanks, Kevin. I'll go for functionality over elegance
anytime! Your instructions were great and it works fine!

Jerry