Macro to export PDF to outlook and send

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
 

ChrisBrennan

New member
Joined
Mar 18, 2013
Messages
4
Reaction score
0
Points
0
To: *****

Subject line :Sheets("Report")Range("B41")

Attachment : Sheets("Charts")Range("A1:O121")or "Attachment" (PDF) (must archive .PDF in specified location and reference, Sheets("Report")Range("B41") as filename)

E-mail body: Sheets("Report")Range("A1:O37") or "Body"(picture enhanced metafile)

I'm using 2010 but if there is anyway of making it work with 2003 that would be great.

Example codes attached.
 

Attachments

  • 132703 CRO Shift Report.xlsm
    281.3 KB · Views: 24
  • Sample Code examples.zip
    4.1 MB · Views: 22
Top