How to Send Email With Attachment From Access Form

[doyle60]

I want to create a form that will send an email with an attached
snapshot. The form needs to have three boxes on it: one to name the
report, another to select the email address, and the last for a
message.

Is this possible?

An example of the form would be:

Report Name: Bay Stores 19788-90
Email: (e-mail address removed)
Message: Please confirm receipt.

The Report Name will be auto filled (based on other selections on the
form) but I would want the code to add the ".snp" on the end of the
name. It should be saved in My Documents.
The Email will be a combo box.
The Message is the body of the email.

Several users will be using the feature, so perhaps there should be a
fourth box to enter the sender's email address.

Matt

 

[pietlinden]

I want to create a form that will send an email with an attached
snapshot. The form needs to have three boxes on it: one to name the
report, another to select the email address, and the last for a
message.

Is this possible?

An example of the form would be:

Report Name: Bay Stores 19788-90
Email: (e-mail address removed)
Message: Please confirm receipt.

The Report Name will be auto filled (based on other selections on the
form) but I would want the code to add the ".snp" on the end of the
name. It should be saved in My Documents.
The Email will be a combo box.
The Message is the body of the email.

Several users will be using the feature, so perhaps there should be a
fourth box to enter the sender's email address.

Matt

I'm pretty sure Stephen Lebans has code for most of this. www.lebans.com
you could output the report to a snapshot file, then attach it. Just
use CDOSYS to automate your e-mail.
with CDOMsg
..To=Me!txtRecipientEmail
..Body="Some message body"
..Subject="Some Subject"
..Attachments.Add("blah blah blah\My Documents\Snapshot.snp")
..Send
End with

or something like that...