Send E-mail with attachment

[BigLouie]

Using MS Access 2007. Have a form open with information. Also have an attachment field. Have a button setup that will send out a report based on the information on the form as a PDF attachment. In addition also need to have as an attachment to the e-mail the PDF that is an attachment to the record open on the form. Is that possible?

 

[traingamer]

Is that possible?

Yes.

What have you tried so far?

Search this forum for email attachment for many instances. Come back wiith specific questions...

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[BigLouie]

Well the code to send out an email with a report based on the record up on the form is no problem. And while I know how to add the .attachemnt.add "" I am unsure as to how to code in the information relative to the attachment to the form. In other words tell the code to use the value in the table in the field Attachment. If that is possible.

 

[traingamer]

If I understand your question (and I'm not 100% certain that I do), simply use the pathname for your table attachment as the pathname for your .attachemnt.add

AttachmentPath = me.txtBoxAttachment.Value
Set objOutlookAttach = .Attachments.Add(AttachmentPath)

I'm assuming that you have the pathname to the pdf attachment available to your code.


Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard