Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Ce site disposera de fonctionnalités limitées pendant que nous effectuons des opérations de maintenance en vue de vous proposer un meilleur service. Si un article ne règle pas votre problème et que vous souhaitez poser une question, notre communauté d’assistance est prête à vous répondre via @FirefoxSupport sur Twitter, et /r/firefox sur Reddit.

Avatar for Username

Rechercher dans l’assistance

Évitez les escroqueries à l’assistance. Nous ne vous demanderons jamais d’appeler ou d’envoyer un SMS à un numéro de téléphone ou de partager des informations personnelles. Veuillez signaler toute activité suspecte en utilisant l’option « Signaler un abus ».

En savoir plus

Ce sujet de discussion a été archivé. Veuillez poser une nouvelle question si vous avez besoin d’aide.

hOW CAN I CREATE A LIST BY COPYING ADDRESSES FROM AN EXCEL FILE WITHOUT THE ADDRESS APPEARING AS THE DISPLAY NAME?

  • 1 réponse
  • 1 a ce problème
  • 11 vues
  • Dernière réponse par sfhowes

dandeg
dandeg
more options

I want to create an email list based on email addresses (120+) that I have in an excel file. If I do copy the column of addresses and paste it into the new mailing list window, the email addresses appear as the display name which I don't want. My preference would be to be able to copy the "name" column and the "address column from excel and have them appear as such in the New List.

I want to create an email list based on email addresses (120+) that I have in an excel file. If I do copy the column of addresses and paste it into the new mailing list window, the email addresses appear as the display name which I don't want. My preference would be to be able to copy the "name" column and the "address'' column from excel and have them appear as such in the New List.

Toutes les réponses (1)

sfhowes
sfhowes
  • Top 10 Contributor
more options

Set up a worksheet with these columns: First Name, Last Name, Display Name, Nickname, Primary Email, and copy your addresses into the Primary Email column. Leave other columns blank if there's no data. Export to csv format. Then, select Tools/Import...Address books... Text file... Files of type: comma separated (csv), select the csv file. Make sure the input fields align with the TB address book fields, and move them up or down as necessary.

This will create a new address book in Address Book, and you can form a mailing list in that book by dragging and dropping contacts.

http://kb.mozillazine.org/Import_address_list_from_text_file

http://kb.mozillazine.org/Thunderbird_:_FAQs_:_Create_Mailing_List