Bit late to the party on this one, but several times a year I email a group of a couple of hundred people from data held in Excel. I have created a separate Excel sheet in the workbook which replicates all of the email addresses in the parent sheet and adds a semicolon to the end of each address. I then copy all of this column into the BCC field in Classic Outlook and paste, followed by Ctrl/K to resolve the address and it works a treat. I've found the semicolon is helpful because if you have also emailed any of these people and their name plus email address is already remembered as an Outlook nickname (is it still called that? - not sure) Outlook can get a bit confused between the name and email address if you have no semicolon.
The other thing I do though is to use SMTP2GO to send via. They have a free plan which offers 200 free per day and 1,000 free per month, so you'd still have to stagger your delivery, but they offer an excellent service with good delivery/bounce info. You can also have them include an unsubscribe footer, with an "Unsubscribed" report back to you, if that's appropriate in your case.
Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly
to your computer or smartphone by using a feed reader.
Trusted
ID Verified
