Hi all.

I have an excel workbook that goes into the thousands of rows.

It tracks sales by sales agent. Currently I am filtering the rows by agent, copying and pasting their sales into an email that gets sent to each and every agent.

Is there a way to have a macro/VBA send one email to each agent with a listing of the sales they have done?

I have attached a sample workbook.

Agents are emailed all the columns.Email rows to people.xlsx