Avatar for Username

Támogatás keresése

Kerülje el a támogatási csalásokat. Sosem kérjük arra, hogy hívjon fel egy telefonszámot vagy osszon meg személyes információkat. Jelentse a gyanús tevékenységeket a „Visszaélés bejelentése” lehetőséggel.

További tudnivalók

A témacsoportot lezárták és archiválták. Tegyen fel új kérdést, ha segítségre van szüksége.

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

  • 2 válasz
  • 4 embernek van ilyen problémája
  • 2 megtekintés
  • Utolsó üzenet ettől: 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?

Összes válasz (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 25 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