Display method, the MailItem object is not 'fully' created. I think it's a sort of VBA bug: if you don't use the. HTMLBody = Head & 'Here the HTML text of your mail' & Signature Set myMail = myOutlook.CreateItem(olMailItem) Then you can simply put your HTML text between Head and Signature: Set myOutlook = CreateObject('Outlook.Application')

Signature = Right(HTMLBody, Len(HTMLBody) - PosSignature + 1) PosSignature = InStr(PosBody, HTMLBody, pTag) ' Search for the position of the tag before signature ' - Trick to split HTMLBody into Head and Signature. ' MailItem need to be displayed to be 'fully created' as object (maybe VBA bug) ' Trick to preserve Outlook default signature Set tempMail = myOutlook.CreateItem(olMailItem) I solved that issue with this trick: Set myOutlook = CreateObject('Outlook.Application') That works, but obviously takes out the HTML formatting of the signatureĮdit 2: The code works on my friend's computer but not on mine Set myOlApp = CreateObject('Outlook.Application')Ĭode to show that signature is automatically inserted: Dim myOlApp As Outlook.ApplicationĮdit: I tried replacing. However the resulting email will be void of any signature.Ĭode to copy and re-insert the signature: Dim myOlApp As Outlook.Application HTMLBody to a signature (string), and then reassign it to. My simple attempt was to save the contents of. This can be seen if you try Outmail.Display. Once you tell VBA to create a new email, it will already contain your default signature. Everything so far is fine, except trying to keep my signature in the email. If you set this signature with logo or image as default signature, the inserted logo or image and original signature information will show in every message you compose automatically.I am trying to automate some emails using VBA for Excel. Note: Up to now you have inserted your logo or image into selected signature. Click the OK button in the Signature and Stationery dialog box. After clicking the Insert button, you can see the logo or image is inserted in the signature.ħ. In the Insert Picture dialog box, select the logo or image you will insert, and click the Insert button.

In the Edit signature section, place the cursor at the position where you will insert a logo or image.Ħ.

In the Signature and Stationery dialog box, select one signature that you will add a logo or image to in the Select signature to edit box.Ĥ. Click the Signatures item in the drop down list.ģ. In the Message window, click the Signature button in the Include group under Message tab.Īpart from the way above, you can also get the Signature button in the Include group under the Insert tab.Ģ.

And then you can insert your logo or images into signature with following steps:ġ. First of all, save your logo as an image.

Insert signature in outlook