Hyperlinked field to email (without writing "mailto:" in address)

A

alioops

We have a hyperlinked field which we use to click on to send an email to the
record's address. At the moment the only way we appear to be able to do this
is by typing "mailto:" before the actual address. Is there some other way of
doing this? Thankyou
PS: We're no experts here!
 
F

fredg

We have a hyperlinked field which we use to click on to send an email to the
record's address. At the moment the only way we appear to be able to do this
is by typing "mailto:" before the actual address. Is there some other way of
doing this? Thankyou
PS: We're no experts here!
Click to expand...

Sure. Don't use a hyperlink field.
Use a regular text field instead.

Enter the email address as text, i.e.
(e-mail address removed)

On your form, code the Text Control's Double-click event:
Application.FollowHyperlink = "MailTo:" & Me![ControlName]

Editing the field is much easier (and inadvertently clicking in it
doesn't send the mail).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hyperlink field to send email 6
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
A couple questions BEFORE using Office 365 0
Keep original senders email address as hyperlink when forwarding 1
Change text to email hyperlink 4
sending email message with Access user defined type error 1
Hyperlink Field Problems 2
Validation of e-mail entries in a hyperlink field, Access 2003 4

Top