Add line breaks and signature to Outlook email

Originally Posted by Leith Ross

Hello Will,

The property is set in the mail item, your object variable OutMail. Copy and paste this into your macro to replace the old code section for OutMail.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

I'm doing something similar to this post but I can't get the email body to format with line breaks and I'd also like to add a signature (stored in outlook). Any help?
Thanks

Hello kirtchristensen,

Welcome to the Forum!

I am not sure this extactly what you need but I can easily change it if needed. I had to develop a new macro for what you want to do. This macro will convert the plain text into HTML code and then add on the HTML signature to the email body. Copy and paste this code into a new VBA module in your workbook. You will need to change the body text and the name of the signature file to what you are using . They are marked in bold text.

Please Login or Register  to view this content.