Sending an Email From Access

  • Thread starter Thread starter rose lentz
  • Start date Start date
R

rose lentz

All I want to do is click on an email address from an
Access form and have the user's email software open up
with the email address populated in the "To" line.
 
All I want to do is click on an email address from an
Access form and have the user's email software open up
with the email address populated in the "To" line.
Click to expand...



Look up DoCmd.SendObject in help.

Richard

Its a good job Einstein never had to fill out one of these Government Grant applications or we never would have found out what e equalled. The West Wing
 
All I want to do is click on an email address from an
Access form and have the user's email software open up
with the email address populated in the "To" line.
Click to expand...

I would suggest the double-click, not click event.
In the address control's double click event:

Application.FollowHyperlink "Mailto:" & [AddressControl]
 
I know this is old and you might not even see this, but if I understand your
question, you can make the email address a hyperlink and have Access do most
everything for you. Hyperlinks usualy have "http://" but for an email
address you would use "mailto:" instead. When doing that, there are a few
other fields you can specify, including the subject. However the total size
is limited and the limitation depends on the client (the user's) email
software. You are likely to be able to use at least 128 characters.
 
Back
Top