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

Creating blank email from access database

P: 6
Hi,

I'm working on a database that contains personal details.

What I'd like to have is a button next to the records email address that when clicked passes the records email address into the "To" field in the blank email.

Any help would be appreciated

Simon Tindall
Dec 6 '07 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
Hi,

I'm working on a database that contains personal details.

What I'd like to have is a button next to the records email address that when clicked passes the records email address into the "To" field in the blank email.

Any help would be appreciated

Simon Tindall

Try this in the on click event procedure of the button where Me!EmailAddress is the name of your forms textbox holding the email address value.

Expand|Select|Wrap|Line Numbers
  1.  Dim strEmail as String 
  2. strEmail=Me!EmailAddress
  3. Application.FollowHyperlink "mailto:" & strEmail
  4.  
Regards

Jim :)
Dec 6 '07 #2

Post your reply

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