Hi Leith
This is all code i have got in my excel spreadsheet.

My spreadsheet has following columns in sheet called "A-D":
A = Company
B = Rate
C = Increment
D = Total Increment
E = Total Rate
F = Date Rate Increased
G = Due Date
H = Person Responsible

When generating email i am looking that if in column G, due date = date -1 then for all those cells get relevant rows information. Therefore if G5 = date -1 then I need information from cell A5, G5 and H5 to put on email. And so on, so if G9 = date - 1 then i want to get info from A9, G9 and H9.

My code currently gets all the info but creates separate email for each cell due date. whereas i want to put them together so only 1 email is created with different rows of data for due dates.

Hope you follow me. let me know if you do not understand any bit.
Thanks
Kamle