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 […]
Tag Archives: email from excel
Sending an email using VBA. It is imperative that you are using Excel 2010 or newer on a Windows PC, and also use Outlook as your email software for this to work. Sub Send_email Dim OutApp As Object Dim OutMail As Object Dim strbody As String Set OutApp = CreateObject(“Outlook.Application”) Set OutMail = OutApp.CreateItem(0) strbody […]
