搜索 | 用户支持

防范以用户支持为名的诈骗。我们绝对不会要求您拨打电话或发送短信,及提供任何个人信息。请使用“举报滥用”选项报告涉及违规的行为。

详细了解

Importing addresses

  • 2 个回答
  • 1 人有此问题
  • 140 次查看
  • 最后回复者为 Stringence

more options

Hello friends,

I'm club treasurer, and our members list changes every week. Members step down, members change their e-mails, and new members join us.

Surnames, given names and e-mail address' are stored in an xls-file.

How do I work Thunderbird best?

With about 100 members, I can't spend time doing this manually in Thunderbird.

When I have an updated list, I want it imported into Thunderbird:

  • names not listed in the import list should be deleted from the address book
  • names listed are left untouched or updated if something has changed
  • new names and address' are imported

This way I have an updated mail-list at all times.

But I don't know how to do this.

Who can please help?

//

Hello friends, I'm club treasurer, and our members list changes every week. Members step down, members change their e-mails, and new members join us. Surnames, given names and e-mail address' are stored in an xls-file. How do I work Thunderbird best? With about 100 members, I can't spend time doing this manually in Thunderbird. When I have an updated list, I want it imported into Thunderbird: * names not listed in the import list should be deleted from the address book * names listed are left untouched or updated if something has changed * new names and address' are imported This way I have an updated mail-list at all times. But I don't know how to do this. Who can please help? //

被采纳的解决方案

I don't know of a way to synchronize an .xls file with a Thunderbird address book. I did a quick search for a Thunderbird add-on to do this, and a Google search, and came up with nothing.

You can export your spreadsheet to a .csv file, then import it into Thunderbird.

Save the list from spreadsheet to a .csv file, with the first row being the column names. See here for a list of field names that Thunderbird can import and their names: http://kb.mozillazine.org/Import_address_list_from_text_file

In Thunderbird, open the Address Book and click on "Tools" in the menu, then "Import".

Select "Address Books" and click "Next". Select "Text file (LDIF, .tab, .csv, .txt)" and click "Next".

In the "Select address book file" window, just above the "Open" and "Cancel" buttons on the bottom right, change the file type to "Comma Separated (*.csv)". Then navigate to where you saved the .csv file you exported from Excel, choose it, and click "Open".

Now you will get an "Import Address Book" window where you will need to match up Thunderbird address book fields with the fields that are in your .csv file. Check mark the fields you want, and move them up or down to match the fields in your .csv file. When done matching, click "OK".

That will create a new address book with the name of the .csv file.

Delete the old address book containing your Member's contact info.

定位到答案原位置 👍 0

所有回复 (2)

more options

选择的解决方案

I don't know of a way to synchronize an .xls file with a Thunderbird address book. I did a quick search for a Thunderbird add-on to do this, and a Google search, and came up with nothing.

You can export your spreadsheet to a .csv file, then import it into Thunderbird.

Save the list from spreadsheet to a .csv file, with the first row being the column names. See here for a list of field names that Thunderbird can import and their names: http://kb.mozillazine.org/Import_address_list_from_text_file

In Thunderbird, open the Address Book and click on "Tools" in the menu, then "Import".

Select "Address Books" and click "Next". Select "Text file (LDIF, .tab, .csv, .txt)" and click "Next".

In the "Select address book file" window, just above the "Open" and "Cancel" buttons on the bottom right, change the file type to "Comma Separated (*.csv)". Then navigate to where you saved the .csv file you exported from Excel, choose it, and click "Open".

Now you will get an "Import Address Book" window where you will need to match up Thunderbird address book fields with the fields that are in your .csv file. Check mark the fields you want, and move them up or down to match the fields in your .csv file. When done matching, click "OK".

That will create a new address book with the name of the .csv file.

Delete the old address book containing your Member's contact info.

more options

Yikes, this is a bulky process.

Batch updates of hundreds of names should be a standard feature.

I've marked it as a solution, since it works.