E-Mail Addresses

D

David Smith

I can't believe that you cannot store e-mail addresses within an Access
table. What I'm hoping to achieve is to store in a column just the relevant
e-mail address, such as (e-mail address removed) and give the user the ability
to send that person an e-mail using Outlook, OE by just clicking on that
expression/hyperlink.

Yes - I can see that by formatting the field as a hyperlink and then
inserting the 'mailto:' expression before the data then I can do what I'm
hoping for - but having to insert mailto: before each bit of data seems
unreasonable. I did wonder about calculated fields but I'm not sure.

Anyone any ideas please?

Cheers

David Smith
MCSE MCDBA (and I still know nothing!!)
 
K

Kevin3NF

I do this by writing code in the OnDoubleClick event of my text control (the
one that holds the email address) to fire up a DoCmd.SendObject....see your
inbox :)

Test file available if you want it
 

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

Unread e-mail count in Samsung Oreo update 3
e-mail field 3
Validation of e-mail entries in a hyperlink field, Access 2003 4
Create an E-Mail field on a form 8
How do I permanently deactivate auto e-mail in Excel? 2
Retrieve E-mail addresses from mailto objects 1
e mail addresses 1
MAILTO Protocol 1

Top