ChrisBrennan
New member
- Joined
- Mar 18, 2013
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hey guys, I'm a new user who found the site out of necessity.
I'm attempting to run a macro that will create a PDF from referenced cells, save the PDF (filename must reference specified cell) in a specified location to be archived, attach the newly created PDF in outlook, then copy a second range from a different sheet within the same workbook and paste the image into the email body as a high quality image (picture enhanced metafile)
I've found example codes that will do what i want but cannot get it to run as one..
I'm not sure if im allowed to post the spreadsheet and example code but im happy to if anyone is interested in helping.
Thanks,
Chris Brennan
I'm attempting to run a macro that will create a PDF from referenced cells, save the PDF (filename must reference specified cell) in a specified location to be archived, attach the newly created PDF in outlook, then copy a second range from a different sheet within the same workbook and paste the image into the email body as a high quality image (picture enhanced metafile)
I've found example codes that will do what i want but cannot get it to run as one..
I'm not sure if im allowed to post the spreadsheet and example code but im happy to if anyone is interested in helping.
Thanks,
Chris Brennan