Hi, I am in need of some advise and assistance. I have a situation where I have many rows of data that refer to a single user. What I would like to do is to create an email (using column E for email address) to that individual, and list out columns B, C, and D for them. So for example let's say my email is listed for rows 2 through 5 (rows 6 through whatever are for others); I would like something similar to this:

Dear MYNAME,

You are included on the following rules:

COLUMNB TITLE COLUMNC TITLE COLUMND TITLE
ROW2,COLUMNB DATA ROW2,COLUMNC DATA ROW2,COLUMND DATA
ROW3,COLUMNB DATA ROW3,COLUMNC DATA ROW3,COLUMND DATA
ROW4,COLUMNB DATA ROW4,COLUMNC DATA ROW4,COLUMND DATA
ROW5,COLUMNB DATA ROW5,COLUMNC DATA ROW5,COLUMND DATA


This would then repeat for the next user and so on so forth until all rows have been included in an email to someone.

I understand how I can create an email through Excel, that isn't the issue. It is combining the data similar to the above and presenting it in an email that I'm stuck. I can conceptualize it in my head but don't know where to start.

I'm hoping someone has done something similar and could point me in the right direction. I've reviewed a hundred examples of sending emails on a row by row basis but not anything similar to this.

Thanks for your time.