We're calling on all EU-based Mozillians with iOS or iPadOS devices to help us monitor Apple’s new browser choice screens. Join the effort to hold Big Tech to account!

Avatar for Username

Etsi tuesta

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Lue lisää

Ketju on arkistoitu. Esitä kysymys, jos tarvitset apua.

No option for email address for import

  • 4 vastausta
  • 7 henkilöllä on sama ongelma
  • 5 näyttöä
  • Viimeisin kirjoittaja Sharp Creations

Sharp Creations
Sharp Creations
more options

I'm importing the 'people' list from outlook.com into a csv file. When I get the choice to realign the Address Book fields to the Record Data to Import, there is no option for 'email address' in the record data to link to. All it imports is the first and last name of the person (which i selected) but I want their email address also. Am I missing something or has the email option been removed for some reason??

I'm importing the 'people' list from outlook.com into a csv file. When I get the choice to realign the Address Book fields to the Record Data to Import, there is no option for 'email address' in the record data to link to. All it imports is the first and last name of the person (which i selected) but I want their email address also. Am I missing something or has the email option been removed for some reason??

Valittu ratkaisu

OK, I created an OutlookContacts.csv file from my Hotmail account and tried to import it in the usual way, and found, like you, there was no email address in the 'Record data to import' column. So, I opened the csv in a csv editor (CSVed) and found that the E-mail Address is in column 48 of a 56 column file. I deleted all the unnecessary columns to make it a 16-column file. After realigning the records up and down and checking the boxes for the relevant fields, the new csv file imported perfectly.

I guess TB has a limit on the number of columns that are read during the import.

Lue tämä vastaus kontekstissaan 👍 2

Kaikki vastaukset (4)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

see my notes here http://thunderbirdtweaks.blogspot.com.au/2013/03/importing-csv-files.html you will probably need to tidy up the million or so fields that Outlook exports to a half a dozen.

Sharp Creations
Sharp Creations Kysymyksen kysyjä
more options

I read your notes, but they don't seem to apply specifically to my situation.

I'm importing the contacts from outlook.com into a csv file. There is not even an option for an email address on the Record Data side for me to realign the Address Book field to ...

sfhowes
sfhowes
  • Top 10 Contributor
more options

Valittu ratkaisu

OK, I created an OutlookContacts.csv file from my Hotmail account and tried to import it in the usual way, and found, like you, there was no email address in the 'Record data to import' column. So, I opened the csv in a csv editor (CSVed) and found that the E-mail Address is in column 48 of a 56 column file. I deleted all the unnecessary columns to make it a 16-column file. After realigning the records up and down and checking the boxes for the relevant fields, the new csv file imported perfectly.

I guess TB has a limit on the number of columns that are read during the import.

Sharp Creations
Sharp Creations Kysymyksen kysyjä
more options

THANK YOU for hanging in there with me in order to replicate the problem. I appreciate it very much!!