E-Mail Addresses

  • Thread starter Thread starter David Smith
  • Start date Start date
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!!)
 
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
 
Back
Top