Tag Archives: excel PDF email

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]datanology.co.uk” 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 […]

Excel VBA – Create a PDF and email it

Before deciding to create a PDF from your worksheet and emailing it, it should be noted that this code is specifically for Windows versions of Excel 2007 onwards and only when Outlook is your email client. It consists of 2 pieces of VBA code although one is more commonly described as a UDF (User Defined […]

the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group