Add multiple lines to one email if multiple conditions are met

[Mikiward]

Hi All,

Hoping you might be able to help..

I've created a VBA code that sends a email when the value in a column to its right is not the same as the value entered in the column entered to its left...

I have 22 columns it does this for , 1st column is the previous value and the second volume is the current value.

For example;
Column 1 is "WTP Feed rate previous value" and Column 2 is "WTP Feed rate current value"

The current value columns actually populate off another sheet where Feed rates are updated. So in the case a feed rate changes , my VBA code will send a email , listing the date the column was changed for (there is a column also with dates) as well as the previous value and current value. Once this is done it will the copy the current value to the previous value.

Given I have multiple columns which are for tracking different Feed rates , I would like to not have to send a email for each different column that changes but rather add a new line to the 1 email.
For example if column 3 differs to 4 add a new line with the changed values to the original already opened email.
I'd like to do this for all 22 columns ...so it creates a list of the changed values in the one email I'm the body text.

Is this possible?

Thanks!!