Email link on a Form

[Xenix]

Hello, I want to have a customer email link that simply opens Outlook and places the address from the email field in it from my cutomer database form when I click on the field. Can anyone help me with this?

 

[BukHix]

This will do it for you:

DoCmd.SendObject , , , Me.Email, , , Me.Subject, "TextToSend", True

This assumes that the Email and subject are going to be pulled from the database. Just rename the Me.Email and Me.Subject to match your controls name. You could also do the same thing with the "TextToSend" field. If you change the true at the end to a false the email will automaticaly be sent without a promt from the sender.

There is a lot of different arguments that you can use to send email, if you have further questions or would like more help be specific with what you want to do including the relevant field/control names.

 

[ptaylor-west]

You can also use this option as an On Click event, just rename the [E-mail Address] to what field name you used

Dim StrInput As String

StrInput = "mailto:" & Me![E-mail Address]

Application.FollowHyperlink StrInput, , True