Email as hyperlink-Additional Info

D

DD

PS. Sorry about 2nd post but I neglected to tell you I
tried to use an update query - email field = "MailTo:&
and the email field appears correct but simply
does not work when I run the query to update the email
field. It seems I have to retype the email field manually.
This is not the end of the world - I only have to manually
update about 100 fields but the most important is to not
force the user to manually enter the mailto: part of the
email address. Thanks!
 
W

Wayne Morgan

The update query should look something like

UPDATE MyTable Set MyTable.EmailField = "Mailto:" & MyTable.EmailField
 

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

Synchronization problems while moving folders to new email 1
hyperlink field to send email 6
sending email message with Access user defined type error 1
Change text to email hyperlink 4
Properties and hyperlinks 0
Hyperlinks on Forms for email address 3
Hyperlinked field to email (without writing "mailto:" in address) 3
USING BUTTON ON FORM TO SEND EMAIL message 0

Top