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