Do not create separate emails - concatenate in one

Hello all,
I have code below doing so that if the due date is date - 1 then it will turn that column cells red. it also sends out email with relevant information in that row. the code is below:

Please Login or Register  to view this content.

above code creates email body as:
Email Automatically Generated By Microsoft Excel on 12/03/2007 13:14:19
To Management
Rate review due date for 13/03/2007
|Company| |Due Date| |Person Responsible|
ABC 11/03/2007 John smith

Regards
Forename Surname
xyz Manager
Company Ltd
Phone: 00000
Fax: 00000
********
2nd email:

Email Automatically Generated By Microsoft Excel on 12/03/2007 13:14:19
To Management
Rate review due date for 13/03/2007
|Company| |Due Date| |Person Responsible|
XYZ 11/03/2007 Peter Dudd

Regards
Forename Surname
xyz Manager
Company Ltd
Phone: 00000
Fax: 00000
*********
which is fine. but when it has several rows with due dates it will create separate email for each. i want to combile all emails so that it looks like below:

Email Automatically Generated By Microsoft Excel on 12/03/2007 13:14:19
To Management
Rate review due date for 13/03/2007
|Company| |Due Date| |Person Responsible|
ABC 11/03/2007 John smith
XYZ 11/03/2007 Peter Dudd

Regards
Forename Surname
xyz Manager
Company Ltd
Phone: 00000
Fax: 00000
****************

Any help will be greatly appreciated. Thank you

Hello Kamle_b,

The email is working correctly. What you don't show is the code used to retrieve the names from the worksheet to be emailed. You need to post that code as well.

Sincerely,
Leith Ross

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