Excel VBA Outlook Email Help!

Thank you for your help, I have amended my original post to comply with the forum rules. I will give this a try in the office tomorrow and let you know how I get on. Thank you once again

Originally Posted by daffodil11

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I'm a fan of HTMLBody over plain ol' Body for the ease with which you can coerce Outlook to change font, size, color, etc. Incorporating the text <br> as a line break gets you a next line. From there you're just concatenating all of your values together.

Please Login or Register  to view this content.

Instead of a clump like I've put together here, I tend to Dim out a number of strVariables and then concatenate them together at the very end, such as:

Please Login or Register  to view this content.

This worked a treat, thank you so much for your help!
One other quick question if I may...
I need to send an email if a cell value is greater than 20 but to only do this once per row. Your help would be much appreciated.

Originally Posted by lqv81s

Thank you for your help, I have amended my original post to comply with the forum rules. I will give this a try in the office tomorrow and let you know how I get on. Thank you once again