E-mail hyperlink

[geraldcor]

I am wondering if there is a way to have a hyperlink open the email program and have the email address be filled into the address box. I can make it open the program but I am wondering if there is any way to have the email address filled in automatically.

 

[dan-cat]

Try this link

 

[ghudson]

Use the Application.FollowHyperlink method like this...

Application.FollowHyperlink "mailto:" & "YourEmailAddress" & "?subject=" & "YourSubject", , True

Set the "YourEmailAddress" address field to either a text string or the value from a text box. Set the "YourSubject" subject field to a text string or the value from a text box.

For a quick test, assign the above command as-is to see how easy it works.

HTH

 

[geraldcor]

This is really silly but how do I set "YourEmailAddress" to the Email Address Text box on my form? That little string really works. Thank You so much.

 

[ghudson]

That little string really works.

Did you doubt it would?

Assuming the email address is displayed in a text box named txtEmailAddress...

Application.FollowHyperlink "mailto:" & [txtEmailAddress] & "?subject=" & "YourSubject", , True

 

[geraldcor]

Thank you so much. It works perfectly.