Sort by e-mail (column B)
Get last row to %LoopMax% #then run this loop
Loop with LoopIndex starting at (row) 2 until %LoopMax%, increment of 1)
Read from Excel (Column B & Row %LoopIndex% to %ThisEmail%
Read from Excel (Column B & Row %LoopIndex + 1% to %NextEmail%
If %NextEmail% = %ThisEmail%
Read from Excel (Column C & Row %LoopIndex%) # then convert the number to %FileName%
Add %FileName% to list %FilesToAttach%
Next Loop
Else
Read from Excel (Column C & Row %LoopIndex%) # then convert the number to %FileName%
Add %FileName% to list %FilesToAttach%
Send e-mail with list of files as attachments
EndIF
End Loop
In plain English, this says, if the next email is the same as this email, don't send an e-mail (yet), just add that file to the list of files to attach. When this is the last of that specific e-mail, add the last file to the files to attach, then send the email with the attachments.
Best of Luck!
