Link to open compose email message

[Mark]

Hi all,
I need to place a input box on a form that when clicked will open the
compose message dialodge box as well as store the email address of the
recipient. I have already created the field in the table, but as simple as it
I cannot figure out how to make the text box a hyperlink that will also open
the email handler. (outlook)

 

[Allan Murphy]

Mark

Try the following code

dim email_to as string

email_to = " & (enter code to put the email address field between the two &)
& "
as an example email_to=" & (e-mail address removed) & "
DoCmd.SendObject , "", "", email_to, "", "", "", "", True, ""

Allan