Extract Embeded PDF Objects From Workbook And Attach To Email Message

[testingcode]

I have an excel file with multiple embedded object PDF's. If you double click the object, adobe reader opens and the PDF is shown.

I'm wondering if it would be possible to attach a macro to the PDF object and have it open a new email. The new email would then have the object(pdf) as the attachment so I can send the pdf to other people. I know how to create a new email and attach a file, but I don't know how to reference the object when I do ".attachments.add"

Thanks in advance.

Ps. Eventually I would also like to be able to attach multiple objects to the same email if that is possible.


Please forgive my "embedded" typo in the title

[Kenneth Hobson]

I see only one method, save the object content as a PDF file. If you have Adobe Acrobat, not the reader, I am sure that is possible. Otherwise, I would have to think about how to save it by some other means.