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

Change the "From" email address VBA 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
Have 4 email addresses Want to auto forward all in one of them 0
Synchronization problems while moving folders to new email 1
Macro: VBA code to move/forward email based on subjects and attachments 0
Opening email client (Outlook) from Form 1
Delete old email address 0
Outlook 2007 has messed up the email addresses for a lot of my contacts 0

Top