Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to include a saved signature from outlook.
I have this macro that runs fine. What I would like to do is add a
signature from me outlook named "work" at the end of this email. Any help is appreciated. Thanks, Paul Sub EmailPDF() Dim MyDate As String MyDate = Date ActiveWorkbook.ExportAsFixedFormat xlTypePDF, "c:\sas \DailyBuildReport" & Format(Date, "mm-dd-yyyy") & ".pdf" Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = " .CC = "" .Subject = "Daily Build Test " & MyDate .Body = "Please reference attached." .Attachments.Add "c:\sas\DailyBuildReport" & Format(Date, "mm- dd-yyyy") & ".pdf" '.Display .Send End With Set olMail = Nothing Set olApp = Nothing End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to include a saved signature from outlook.
Start here Paul
http://www.rondebruin.nl/mail/folder3/signature.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Paul Lambson" wrote in message ... I have this macro that runs fine. What I would like to do is add a signature from me outlook named "work" at the end of this email. Any help is appreciated. Thanks, Paul Sub EmailPDF() Dim MyDate As String MyDate = Date ActiveWorkbook.ExportAsFixedFormat xlTypePDF, "c:\sas \DailyBuildReport" & Format(Date, "mm-dd-yyyy") & ".pdf" Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = " .CC = "" .Subject = "Daily Build Test " & MyDate .Body = "Please reference attached." .Attachments.Add "c:\sas\DailyBuildReport" & Format(Date, "mm- dd-yyyy") & ".pdf" '.Display .Send End With Set olMail = Nothing Set olApp = Nothing End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to include Excel charts in Outlook email *body* with VB | Excel Programming | |||
Sending emails from Excel with Outlook Signature | Excel Discussion (Misc queries) | |||
Digital Signature Email | Excel Programming | |||
Outlook Signature after Attachment | Excel Programming | |||
Add signature to files exported to Outlook | Excel Programming |