搜索 | 用户支持

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

详细了解

How to Import csv e-mail addresses in format xxx<e-mail address>

  • 4 个回答
  • 1 人有此问题
  • 4 次查看
  • 最后回复者为 Matt

more options

I have a list of 45 e-mail addresses in the above format. However when I use the import wizard when I get to the Import Address Book window, the right hand side simply shows the e-mail addresses in my csv file and I am unable to import the e-mail addresses even when only e-mail addresses are checked on the left column.

I have a list of 45 e-mail addresses in the above format. However when I use the import wizard when I get to the Import Address Book window, the right hand side simply shows the e-mail addresses in my csv file and I am unable to import the e-mail addresses even when only e-mail addresses are checked on the left column.

所有回复 (4)

more options

does you CSV file start with a heading naming the email addresses.

Please check your CSV file is formatted as a comma separated values file and not just a plain text file with data in it.

See https://thunderbirdtweaks.blogspot.com.au/2013/03/importing-csv-files.html

Where I tried to explain importing CSV files to Thunderbird.

more options

I have it both in a csv and a txt fle. They contain nothing but the e-mail addresses in the form XXX<e-mail address> where XXX is the Display Name. I know how to delimit the addresses in any way by using find-replace. I reviewed your post but it appears that you are assuming the file to be imported contains a first and last name, which I don't have other than what's in the display name. Using Data Import I have been able to create a csv file in Excel with one row and each column containing an e-mail address in the above format. But I haven't been able to import it into Thunderbird

more options

You need one contact per line, and the lines are split into columns at the commas (though other text delimiters are available.) That's how CSV works.

Giuseppe Verdi,gv@example.com
Fred Delius,fred.delius@example.com
Maurice Ravel,mravel@example.com
Wolfgang Amadeus Mozart,wam@example.com

You can use a copy-and-paste in Excel where you copy your row, and swap rows for columns when pasting.

If you follow the advice given by Matt, you can probably construct a display name column. And you can probably parse your display name entries into first name and last name (you don't need to do this, but may wish to do so for your own convenience when sorting and searching.) It may not be 100% accurate, but you will be able to reduce the amount of hand-editing to just the names which confound your data parsing. Here, Herr Mozart presents us the challenge of using two forenames.

more options

You said the magic word. Excel.

Did you get the bit where I said Excel output can not be used without first passing it through notepad to correct the deficiencies of Excel?