Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am attempting to generate an an email message (Outlook 2007) from my EXCEL
VBA. All is working but for the fact that the message does not include my default signature. Any suggestions? Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .To = " .CC = "" .BCC = "" .Subject = "XXX" .body = .body & "insert text here '.Attachments.Add ActiveWorkbook.FullName 'You can add other files also like this .Attachments.Add ("filename.xls") .Display 'or use .Display or .send End With On Error GoTo 0 Set OutMail = Nothing Set OutApp = Nothing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Email signature and sending an excel 2007 spreadsheet | Excel Discussion (Misc queries) | |||
how can i insert MY signature into an excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I insert an auto signature if emailing from excel? | Excel Discussion (Misc queries) | |||
Email Body Text & Signature | Excel Programming | |||
Digital Signature Email | Excel Programming |