attaching a record's attachments to a mail message

[joyd]

i have managed to create a button which will create a pdf of a report of a
single record and attach it to an e-mail ready to be sent, but doing so does
not include my record's attachments (added using access 2007 attachment field
type system), which are not included in the pdf, neither have i found a
method to export the record including it's attachments. is there a code that
will add to the email with the pdf of my report the attachments of that
record?

thanking you in advance,

thanos

 

[ajetrumpet]

i posted a "send emails with outlook" thread in the FAQ section here. if you use OL, take a look. the code in that article uses the attachment field in an instance of OL. you may be able to use that as a guide to attaching your files that are in your attachment fields. I can't remember just now, but if the those fields store the URL instead of just an icon, use those URLs when putting values into the attachment fields in the OL instance.

 

[darbid]

here is a similar thread where I gave a "long way" example of sending an email with attachments. If you already know the attachment paths then you can skip the filedialogue. But remember that adding file attachments to an EmailItem is NOT like adding TO ie you cannot just put a ";" in between each one.

http://www.access-programmers.co.uk/forums/showthread.php?t=182637