Send email from Access form

[Bret]

In a form, I want to give the users the ability to automatically open OUTLOOK
to write and send an email. I also want to automatically populate the
subject line and 'send to' line, all thru the button_click event in the form.
How do I do this in code?

thanks in advance.

 

[Steve Schapel]

Bret,

It depends on what you want the subject line and the send to line to
say. But in the meantime, have a look in Help under SendObject. There
is also some good information at http://www.granite.ab.ca/access/email.htm

 

[JoanOC]

See From Discussion Group:Access General Questions
Re: Email Button code Problem 11/5 fredg
for instructions. It works. I did it yesterday.
Briefly, you open the Form in design view.
If you want to use a command button code the button click event:
Application.FollowHyperlink"MailTo:" &[ControlName]
This will open whatever ISP you have and automatically insert the address of
the record you are on.
Joan