Hi, I am very new to VBA but can follow the basic logic fairly well.
I have a list of people on sheet 1, column A. The corresponding information for each person is listed across 5 columns in sheet B (cols A:E). **The row numbers are consistent throughout the sheets (ie. Joe is listed in Row 5 on sheet 1, and his name and info is listed in Row 5 cols A:E on sheet 2).
<tbody>
</tbody>
What I want to do is to customize this weekly report for each person: Joe gets only HIS information emailed to him in a "template" that would be standard for each person (see below) -- the template would be the words in blue with the corresponding info, and this would be put directly into the BODY of the email
<tbody>
</tbody>
This would be repeated for all people on the list (100+). I think I can figure out some email code, but it is getting the information into the SAME template for each person repeatedly (not sure how to write a loop for this including the template)
Thank you so much for any help you can offer!!!!!
I have a list of people on sheet 1, column A. The corresponding information for each person is listed across 5 columns in sheet B (cols A:E). **The row numbers are consistent throughout the sheets (ie. Joe is listed in Row 5 on sheet 1, and his name and info is listed in Row 5 cols A:E on sheet 2).
Name | June Sales | Sales Quota | YTD Sales | Total June Payout |
Joe | $5000 | $3000 | $20,000 | $4,000 |
Susan | $4500 | $3500 | $21,000 | $4,000 |
<tbody>
</tbody>
What I want to do is to customize this weekly report for each person: Joe gets only HIS information emailed to him in a "template" that would be standard for each person (see below) -- the template would be the words in blue with the corresponding info, and this would be put directly into the BODY of the email
Name | June Sales | Sales Quota | YTD Sales | Total June Payout |
Joe | $5000 | $3000 | $20,000 | $4,000 |
<tbody>
</tbody>
This would be repeated for all people on the list (100+). I think I can figure out some email code, but it is getting the information into the SAME template for each person repeatedly (not sure how to write a loop for this including the template)
Thank you so much for any help you can offer!!!!!
Last edited: