Multiple Issues: Macro not opening new email message or email body not updating

Hi ratcat,

MS Excel Version Office 365

Please update your profile to reflect your Office Version.
-----------------

After looking at your code it looks like you want:
a. HTML body
b. Range as a picture in the Body
c. Standard Outlook Signature
d. Attachment

Try the following code which is included in the modified copy of your Sample Workbook:

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). https://www.excel-easy.com/vba/examp...-explicit.html

Lewis

Please NOTE that HTML code is NOT allowed by the ExcelForum Firewall. Replace all occurrences of '$$$' with '<' and all occurrences of '%%%' with '>' above