I'm trying to create a code that will create a PDF from a specified range, attach the newly created PDF in outlook, then copy a second specified range within the same workbook and paste the image into the email body as an object
(Ideally the PDF's filename would reference a specified cell and be archived in a specified location but I'm not too concerned about that.)
I've got to a stage where I can get either the PDF to attach itself and send, or the object inserted into the body and send but cannot combine the two.
I've attached the file, alone with the code.
Any help/ideas would be greatly appreciated
Thanks,
Chris Brennan
Bookmarks