VB code to e mail multiple recipients through Outlook

Hi Guys,

I have a main table (attached below) which holds a grid of information for several people,

I need a macro on a push button which will auto - send each agent their information through Outlook Email.

I know this can be done through VBA but I have no idea how!

So for example, on the sheet, Agent 1 would recieve an e mail stating:

Agent1,
Here is your board for week 41:
You sold 2 products,
Your Wrap time was 45%,
You actioned 68% of prompts
You collected £645
You setup 2 MDDs
You were in paperwork for 25 minutes
Well Done

Team: Keep up the good work!


There are 8 fields which need to be agent specific and the TEAM COMMENT and WEEK NUMBER are universal.

If anyone can help with this or point me in the right direction I would be eternally greatful!

Thanks in advance

F