launch outlook through hyperlinked email address

[jennymac]

Hi, I am a volunteer for a small not for profit organization. I got the job to develop a database to store member info b/c I did a 3 day course on Microsoft Access. In the database, one of the fields is 'email address'. I want the field hyperlinked through VBA code so that when I click the address, outlook/outlook express opens a new email to send. Has anyone written the code to do this so that I can cut and past into my database? I use Access 2003. Cheers

[AricC]

Jenny,
I posted a link to your thread in the Access forum someone should be able to assist you better. Use the Access forum, not all the experts on TSDN check the general forums.

Welcome,
Aric

[jennymac]

Jenny,
I posted a link to your thread in the Access forum someone should be able to assist you better. Use the Access forum, not all the experts on TSDN check the general forums.

Welcome,
Aric

Thanks Aric,
I'm very new to this- appreciate the help.
Jenny

[AricC]

Thanks Aric,
I'm very new to this- appreciate the help.
Jenny

No problem, this site has some real "Access Experts" if you need help I would post in that forum, .

[NeoPa]

I'm not very experienced with e-mailing in code I'm afraid.
However, if you're not particular about needing the client then, VBA can e-mail something directly for you - without operator involvement.
I can't remember the exact command - as I say I don't use it myself - but a trawl through the Access forum should find something. I know it's been asked about before.

[ronverdonk]

I'm not very experienced with e-mailing in code I'm afraid.
However, if you're not particular about needing the client then, VBA can e-mail something directly for you - without operator involvement.
I can't remember the exact command - as I say I don't use it myself - but a trawl through the Access forum should find something. I know it's been asked about before.

Just display an <a link on your screen and anyone who clicks opens the default email client. [html]<a href='mailto:yo u@yoursite.com' >Send an email</a>[/html]

Ronald

[MMcCarthy]

Hi, I am a volunteer for a small not for profit organization. I got the job to develop a database to store member info b/c I did a 3 day course on Microsoft Access. In the database, one of the fields is 'email address'. I want the field hyperlinked through VBA code so that when I click the address, outlook/outlook express opens a new email to send. Has anyone written the code to do this so that I can cut and past into my database? I use Access 2003. Cheers

If you change the datatype of the field 'email address' to hyperlink it should open the default outlook or outlook express with a new email. You may have to add 'mailto:' before some or all of the addresses already entered.

Mary