I want to add a group of addresses to a list without typing each one individually
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)
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
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