Split worksheet with many rows into separate files based on changes in one column

Hello.
I have a problem I'm trying to solve and am hoping someone on here might be able to help.

I have a spreadsheet with about 55 columns and 3,000 rows. Each row belongs to one of 103 different individuals.
Each of the records contains the person's name and their email address.

I want to send 103 separate emails (via Outlook) where each email includes an attachment of that individual's records.
The body of the email will be the same for each person. The only thing that will be different for each one is the attachment.

If someone can help me create separate files based on the spreadsheet, I don't mind doing the emails manually and attaching.

However, if someone can help me figure out how to automate the whole process, that would be great.

Any help or insight is appreciated.
Thanks for reading.

Regards,
Thom

I've attached a sample file. Based on this, I want to create 3 separate emails, each with the same body, but each has a different file attachment.
Hope that makes sense.

Thanks Ron. Unfortunately, I'm looking to have the files fully generated and attached to an email and sent out. Manually creating the files and sending the emails will take me most of the day. I'm looking to automate it so I can use the same method in the future.