Sending an Email From Access

[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.

 

[Richard]

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.

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

 

[fredg]

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.

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

Application.FollowHyperlink "Mailto:" & [AddressControl]

 

[Sam Hobbs]

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.