Consolidate Excel Information in one e-mail for each user

My table is structured as:

Capturar.PNG

I need to consolidate everything that is pending for the seller "Andrew or Joseph" and send a single email with the "OS" list. I am using the following code but unsuccessful as it opens a new email for each row of the worksheet:

HTML Code: 

your FOR loop will send 1 email for each row, so instead,
use the for loop to collect all the emails.

Please Login or Register  to view this content.

THEN, send the 1 email:

Set OutMail = OutApp.CreateItem(0)
'...etc....