By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

launch outlook through hyperlinked email address

P: 2
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
Share this Question
Share on Google+
6 Replies


Expert 100+
P: 1,892
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

P: 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

Expert 100+
P: 1,892
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
Expert Mod 15k+
P: 31,186
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
Expert 2.5K+
P: 4,258
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
Expert Mod 10K+
P: 14,534
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.