Bastien Mensink’s Excel Blog at ASAP Utilities explains how Mozilla Thunderbird users can write to a set of e-mail addresses that’s held in an Excel spreadsheet.
“Yesterday a friend of mine called. He had a list of contacts he kept in Excel and he wanted to send out a new years letter to all of them. He knew he needed to use the BCC field to do this (to hide everyone’s address for the others) but he didn’t know an easy way to copy a bunch of email addresses from Excel into the BCC field of his email message.”
According to the article, “How to copy addresses from excel to your new years email-message“, you can do this either one of two ways:
- Simply copy and paste the column of addresses from Excel, into Thunderbird’s BCC field. This may or may not work.
- Use a bit of Excel trickery to merge the column of e-mail addresses into a single cell, with each address separated by a comma. Copy and paste this comma-separated list into Thunderbird’s BCC field.
For complete instructions on carrying out step two, read Bastian’s article.
Bastian also reminds you to check with your Internet Service Provider if option two doesn’t contact everyone. Some ISPs limit the number of recipients allowed on a single e-mail message.
