I have a list in Word of email addresses. How can I get them into the bcc field of an email
I want to write an email to 50 addressees. I have a list of the email addresses in Word. I can separate them by paragraphs or commas etc. How can I get them, en masse, into my email as BCC adresses. I would also like them not to go into my address book. This is a once only email.
Sally
Chosen solution
Item 1. Addresses go in your address book. There is no where else to put them. Don't want thenm in your personal address book. Add another one.
Item 2. You must format the addresses as a CSV file and save them in word as such. Excel or any spreadsheet will do a better job of that than Word.
Item 3. The CSV file must be safed as UTF-8 text. Excel I know does not do that an additional step to open the file in notepad and explicitly select UFT-8 in the save as dialog is required for Excel.
Item 4. The CSV file must be im ported into Thunderbird address book using the import menu item.
Item 5 You must align the headings from the CSV file explicitly with the ones Thunderbird uses, otherwise the email address you import will not be in the email address field.
Alternatively you can create a single line with the email addresses in Word. Separated by a comma and copy and placing your cursor in the BCC field use the keyboard shortcut Ctrl+V to paste into the email header. Note that This is not technically supported and if you mess up the spaces and commas with things like tabs or hard returns all you will get is a mail that does not send.
All Replies (1)
Chosen Solution
Item 1. Addresses go in your address book. There is no where else to put them. Don't want thenm in your personal address book. Add another one.
Item 2. You must format the addresses as a CSV file and save them in word as such. Excel or any spreadsheet will do a better job of that than Word.
Item 3. The CSV file must be safed as UTF-8 text. Excel I know does not do that an additional step to open the file in notepad and explicitly select UFT-8 in the save as dialog is required for Excel.
Item 4. The CSV file must be im ported into Thunderbird address book using the import menu item.
Item 5 You must align the headings from the CSV file explicitly with the ones Thunderbird uses, otherwise the email address you import will not be in the email address field.
Alternatively you can create a single line with the email addresses in Word. Separated by a comma and copy and placing your cursor in the BCC field use the keyboard shortcut Ctrl+V to paste into the email header. Note that This is not technically supported and if you mess up the spaces and commas with things like tabs or hard returns all you will get is a mail that does not send.