Change format of email addresses

S

Stephen Glynn

I've got my email addresses stored as hyperlinks, and I've used the code
I found at
http://support.microsoft.com/default.aspx?scid=kb;en-us;323202&Product=acc2000
('HOW TO: Change the Values in a Hyperlink Field from an HTTP Address to
a MAILTO Address in Microsoft Access 2000') to insert 'mailto:' in
front of them so that when I click on the link in a form it launches my
email client with the email address properly filled in.

So far, so good.

However, I've also found some code that allows me to send an email
directly from an Access form, using the contents of a memo field as its
contents (at
http://www.databasedev.co.uk/email-from-ms-access-form.html). This
takes Me.EmailAddress and inserts it into the Address field in my email
programme. Unfortunately, that means I'm trying to send emails to
'#mailto:[email protected]', which doesn't work.

How do I strip out the '#mailto:' ?

Steve
 

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

Opening email client (Outlook) from Form 1
Keep the # signs out of hyperlinks and mailto 3
How do I format a field in a table to default to email (mailto:)? 3
mail merge 1
access field trim email to:[email protected] to [email protected] ? 2
E-Mail Addresses 1
E-Mail Addresses 0
TO and CC email addresses hidden when forwarding an email [Outlook2007] 3

Top