Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

I have a list in Word of email addresses. How can I get them into the bcc field of an email

  • 1 reply
  • 5 have this problem
  • 45 views
  • Last reply by Matt

more options

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

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.

Read this answer in context 👍 2

All Replies (1)

more options

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.