email from a form

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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?
 
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
 
Thanks, Kevin. I'll go for functionality over elegance
anytime! Your instructions were great and it works fine!

Jerry
 
Back
Top