500+ emails in one blast

Need to find a way to send approximately 500 emails, each with a spreadsheet attachment, to 500 respective client stores at once.

The tricky part is, each spreadsheet will have a different prefix number in the spreadsheet as a store identifier. Therefore, in that respect, each spreadsheet will be a different spreadsheet. So, 500 emails, with 500 different spreadsheets, respectively, in one email group to be sent in one SEND.

As mentioned, these are client emails, therefore, not in our domain. I thought of creating a group in Outlook 2013 "Contacts", add or import each email address to the group. Email blast solved. Again, if the spreadsheets were all the same I'd add the attachment to the email to send, add the email group and send. BUT, each attachment is different (albeit, similar). Can this be done? Thanks.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
No. Different attachments means different emails. You need to send each mail individually.
The only other way I can imagine is to send the same spreadsheet, containing a macro on first open, doing the necessary changes and saving the result.
A more indirect approach is to send a link only, and generate the sheet on the fly when using the link (to a web site, for example).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.