email from a field

[agorman]

I have a form that has a text box field so I can type in 'Bob's' email address.

Is there a way that I can then double click on that text box to open Outlook Express (my default mail client) ready to send an email to 'Bob' ? (similar to mailto:

Thanks

Adrian

 

[pbaldy]

You can use SendObject in VBA to do that. More info in Help. I think you can also use FollowHyperlink in VBA and use MailTo.

 

[agorman]

Thanks

Thanks Paul,

I found this code which seems to work great:

Dim StrInput As String
StrInput = "mailto:" & Me![EmailAddress]
Application.FollowHyperlink StrInput, , True

Adrian