469,364 Members | 2,469 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,364 developers. It's quick & easy.

launch outlook through hyperlinked email address

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
Dec 27 '06 #1
6 5653
AricC
1,892 Expert 1GB
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
Dec 27 '06 #2
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
Dec 27 '06 #3
AricC
1,892 Expert 1GB
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, .
Dec 27 '06 #4
NeoPa
32,185 Expert Mod 16PB
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.
Dec 30 '06 #5
ronverdonk
4,258 Expert 4TB
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:you@yoursite.com'>Send an email</a>[/html]

Ronald
Dec 30 '06 #6
MMcCarthy
14,534 Expert Mod 8TB
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
Jan 1 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Google Mike | last post: by
3 posts views Thread by Chuck Farah | last post: by
2 posts views Thread by Phil Stanton | last post: by
4 posts views Thread by lauren quantrell | last post: by
1 post views Thread by Thejus | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.