I have a mail merge routine set up that uses Outlook (not express).
The code looks like this:
Public Sub RunOutlook()
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
'the following line could be populated from a a field in a table
.To = RecipientList!Address
.Subject = RecipientList!Header
.Body = RecipientList!messagebody
.Display 'change to .Send to send without review
Set OutMail = Nothing
Set OutApp = Nothing
I need to insert a logo above the message. I've tried playing with the signature within Outllook, but I'd like to do this without having to set up individual Outlook apps.