Need to Email several Items related to each person in each email

[kiranpat]

Hi all,

I am working on a file that requires me to send several emails of transaction details.
I want to automate this process using excel macros, here is my requirement
* All row items related to one person should be sent in one email (filter based on names and select the related items)
* All the related row items need to be pasted on body of the email as a Table along with some text (as shown in attachment)
* Raw Data contains some column fields that are not required on the body of the email.
* Row Items that are to be sent are decided by column N (if Yes, need to Send if no then need to omit that row)
* Need to know in column O if mails were sent or not

I have attached the sample file for reference.

any help would be of great help.

Regards,
Kiran

[kiranpat]

Any Help would be of great help...