I have an Access question that I'm hoping you can help me with.
I'm using some code in Access VBA to generate some emails in Outlook. The emails get created fine, except that I would like them to include the default Outlook signature. Is that possible?
Here is my code:
Dim appOutLook As Object Dim MailOutLook As Object Dim mess_body as string Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(0) mess_body = "here's where I put the body of the email" With MailOutLook .To = DLookup("email", "CatWebWork2PrimaryContactQ") .Subject = "Catalog Page Proofs" .Body = mess_body & .Body .Save End With