Macro to Print in PDF embedded with another file(s) and attach to email

[Chow Chow]

Hi All

I am new here.
I know there is a macro to print in PDF and send as attachment by email.
My requirement is to generate a PDF file and another file(s) attached within the PDF and then email

Please help!
Chow Chow

 

[Luke M]

Hi Chow Chow, and welcome to the forum!

Check out the tutorial here to get started:
http://www.rondebruin.nl/win/s5/pdf.htm

Ron does a great job including comments in his code, should be easy enough to follow and add an additional attachment, if that's what you need.

 

[Chow Chow]

Hi Luke,

Thanks for the reply and link.
But my requirement is to generate a pdf file with attachments within it.
I have attached a sample pdf within which 2 other files are attached.
Let me know what you think.

Thanks!

 

[Luke M]

Then no, you can't do that just from XL. I believe attaching documents to a PDF requires more than the basic PDF reader, which is all that XL has access to.

Also, IMO, not a big fan of attachments within PDFs, as many people don't know how to check that the attachments even exist.

 

[Chow Chow]

(

Thanks Luke.