Avatar for Username

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

This thread was archived. Please ask a new question if you need help.

I want to add a group of addresses to a list without typing each one individually

  • 2 replies
  • 4 have this problem
  • 2 views
  • Last reply by sfhowes

Brian
Brian
more options

I have a long list of names and email addresses collected in a Word document. I want to make it a list in the Thunderbird address book. How can I transfer all these into a list without tediously copying each one over into the contacts form?

I have a long list of names and email addresses collected in a Word document. I want to make it a list in the Thunderbird address book. How can I transfer all these into a list without tediously copying each one over into the contacts form?

All Replies (2)

Diego Victor
Diego Victor
more options

The emails are everyone in a line or separated by comma or dot comma? If yes just select all, copy, go to Address Book >> New list paste all addresses, you will see all in one line but confirm by clicking on OK button, then open again the list and you will every address in one line

sfhowes
sfhowes
  • Top 10 Contributor
more options

Create a new Excel document with these column names:

First Name,Last Name,Display Name,Nickname,Primary Email

Copy the names from your Word document into the columns (e.g. Display Name = First Name + Last Name), and leave a column empty if it's not needed, e.g. Nickname.

Save the Excel document as a comma separated (csv) file. In TB, Tools/Import...Address books...Text file... Files of type: comma separated, then select the csv file. Check that the input fields match the address book fields, and the list will be displayed as a new address book in Address Book.

If you want to create a mailing list for this address book, create a new list from File/New/Mailing List, name the list, close it, then drag the contacts from the address book onto the mailing list icon.

http://kb.mozillazine.org/Import_address_list_from_text_file