Further study on Auto-mail for due date reminder

I had made one excel to send automatic due date reminder mails via Groupwise (made with the help of your forums only).

The problem I am facing is as below:

[Also note, problem is not whether Groupwise or Outlook, problem is its generating multiple emails for each due item]


This is generating multiple emails and even the items not due are generating blank mails.

I would like to generate only one mail with different items different expiration dates.

After that group the identical addressees and compose one message with all the relevant data.


Right now its sending 3 mails as:


Mail 1: Please take notice of the following expiration date(s):

-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.

-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.

Sent at 17-Sep-13 11:11:04 AM


Mail 3: Please take notice of the following expiration date(s):

-Equipment C Job cccccc expiration date : 19-May-13 -121 days.

-Equipment C Job cccccc OVERDUE : 19-May-13 -121 days.

Sent at 17-Sep-13 11:11:04 AM


And the ones not due, going blank, i.e: the mail body (Mail 2) text reads:

"Please take notice of the following expiration date(s):

Sent at 17-Sep-13 11:11:04 AM"



What I wanted was a single mail with following in the mail body (Example):



" Please take notice of the following expiration date(s):

-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.

-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.

-Equipment C Job cccccc expiration date : 19-May-13 -121 days.

-Equipment C Job cccccc OVERDUE : 19-May-13 -121 days.



Sent at 17-Sep-13 11:11:04 AM"

Is this possible? Please check my VBA code & kindly help me resolve this.