Tag Archives: automate emailing from excel

PDF and email together

This is a newer and more efficient way of creating a PDF, saving it and emailing it out. Sub pdf_and_email() FName = “[email protected]” DDate = Format(Now(), “mm-dd-yyyy-hh-mm-ss”) Subj = “Subject of email here” ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ ThisWorkbook.Path & “\” & FName & “.pdf”, Quality _ :=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False ‘Send the PDF out here […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group