par arnob » 15 Nov 2010 14:30
bonjour,
trouvé sur le net, en anglais désolé :
1re solution : Import an Excel file of addresses: (You must first save the excel file as a comma delimited .csv file)
Select Tools-Addressbook.
Select Tools-Import.
Select Addressbook from options. Click Next.
Select Text file from the options. Click Next.
Navigate to where you saved the .csv file. Change the file type to All Files. Select the .csv file and click Open.
Match the fields: E-mail to E-mail, Name to Name. Click Ok. Click Finish. (Imported file is now a new addressbook in the folder list.)
2ème solution :
1. open Thunderbird > Address Book > Export > save the address book as csv instead of ldif.
2. open the csv in Notepad.
3. open the excel csv in Notepad too.
4. compare the two.
5. use Notepad Find & Replace to quickly correct the excel csv file to use the same formatting as the TB csv file.