Outlook macro to insert template

Question

I'm sure this question has been asked a hundred times with variations on it as well. I have done my best to research but I can't quite find the right information to suit my needs.

I currently have a working macro that will create an email reply and include a template, however it is not showing signatures correctly (missing images).

There are two ways I can go about this;

Firstly, If there was a way to fix up my current code (below) to work better with signatures so every user can have their default signature show up correctly.

The second way is to be able to insert the template contents into the current open reply (which would already have the signature showing). This is the ideal and preferred way but I couldn't find the correct information on how to insert the template into the currently open email. Preferably without removing anything already existing in the body, essentially just pasting the contents.

This is my current code to reply with the template.

Sub includeChecklist()
    Dim origEmail As MailItem
    Dim replyEmail As MailItem

    Set origEmail = Application.ActiveWindow.Selection.Item(1)
    Set replyEmail = Application.CreateItemFromTemplate("C:\Users\user\AppData\Roaming\Microsoft\Templates\Checklist.oft")

    replyEmail.To = origEmail.Sender
    replyEmail.CC = origEmail.CC
    replyEmail.Subject = origEmail.Subject
    
    replyEmail.HTMLBody = replyEmail.HTMLBody & origEmail.Reply.HTMLBody
    replyEmail.Display
End Sub

Any help is appreciated.

This question had been asked and answered multiple times. See, for example, https://stackoverflow.com/questions/8994116/how-to-add-default-signature-in-outlook — Dmitry Streblechenko, Mar 30 '22 at 02:01
And https://stackoverflow.com/questions/41967330/sending-email-via-outlook-using-win32com-and-adding-signature-file — Dmitry Streblechenko, Mar 30 '22 at 02:01
And https://stackoverflow.com/questions/51381449/adding-signature-to-an-automated-outlook-mail — Dmitry Streblechenko, Mar 30 '22 at 02:02
Does this answer your question? [How to add default signature in Outlook](https://stackoverflow.com/questions/8994116/how-to-add-default-signature-in-outlook) — Eugene Astafiev, Mar 31 '22 at 17:50

Outlook macro to insert template

0 Answers0