I know there have been a bunch of threads on this but I tried a bunch of solutions but having problems getting my Outlook Signature added. With out posting all the variations of trying to ad olSignature As String ETC here is the working version of where I am trying to put the sig... All help is greatly appreciated.
VBA Code:
Public Sub Send_Email(toEmail As String, Optional fileAttachment1 As String, Optional fileAttachment2 As String)
Static olApp As Object
Dim olMsg As Object
If olApp Is Nothing Then Set olApp = CreateObject("Outlook.Application")
Set olMsg = olApp.CreateItem(0)
With olMsg
.To = toEmail
.CC = "cced.email here"
.Subject = "Subject"
.HTMLBody = "Body Her"
.Attachments.Add fileAttachment1
.Attachments.Add "C:\Users\blah\Documents\Options.pdf"
.Send
End With
End Sub
Sub SendEmailWith2Attachments()
Call Send_Email("addressX@somewhere.com", "c:\user\anonymous\report.pdf", "C:\Users\blah\Desktop\Working Email Version Cheshire\Forms\Training Options.pdf")
End Sub