M
MarkV
I'm baffled. The following code gives me everything on the e-mail that I want; attachments, designated signature. But the signature is on top, followed by the attachments, followed by the body. Does anybody know why this might be? One solution I've been working on is trying to retrieve a signature as a string and include it in HTMLBody which will put the attachments on their own line. Any help would be greatly appreciated.
Dim appOutLook As Object
Dim MailOutLook As Object
Set appOutLook = New Outlook.Application
Set MailOutLook = appOutLook.CreateItem(olMailItem)
MailOutLook.Subject = "Topic"
MailOutLook.Body = "Test"
MailOutLook.Attachments.Add ("C:\file.xls")
MailOutLook.Attachments.Add ("C:\file2.xls")
MailOutLook.To = "people"
'MailOutLook.Cc = copyto
MailOutLook.Display
Set inspect1 = MailOutLook.GetInspector
inspect1.CommandBars.ActiveMenuBar.Controls("Insert").Controls( "Signature").Controls("Sig1").Execute
Dim appOutLook As Object
Dim MailOutLook As Object
Set appOutLook = New Outlook.Application
Set MailOutLook = appOutLook.CreateItem(olMailItem)
MailOutLook.Subject = "Topic"
MailOutLook.Body = "Test"
MailOutLook.Attachments.Add ("C:\file.xls")
MailOutLook.Attachments.Add ("C:\file2.xls")
MailOutLook.To = "people"
'MailOutLook.Cc = copyto
MailOutLook.Display
Set inspect1 = MailOutLook.GetInspector
inspect1.CommandBars.ActiveMenuBar.Controls("Insert").Controls( "Signature").Controls("Sig1").Execute