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.