Email Reminder for Highlighted Rows & Email Addresses

[xerksis]

Hi,

I'm an intermediate user of Excel and fairly new to VBA, so kindly bear with me.

As per the below code, I can successfully generate the email. But I need to tweak it further to achieve the following :

1. I need to input the email addresses in the 'To' section of the email, based on the individuals initials. The addresses would be provided in a separate column legend.
2. If there is more than one task (in separate rows, which I would highlight), how would I combine them into one mail notification. They could show up one below the other. The code below only works for 1 row at a time. But some individuals have multiple tasks and I wouldn't need to send them multiple mails.

Please Login or Register  to view this content.

I have also attached a copy of the file, so you would understand better what I'm trying to achieve.

Thanks in Advance for your most helpful replies.

Cheers !

[xerksis]

Bump....hoping someone can help me with this.....even partially.....