Avatar for Username

Sykje yn Support

Mij stipescams. Wy sille jo nea freegje in telefoannûmer te beljen, der in sms nei ta te stjoeren of persoanlike gegevens te dielen. Meld fertochte aktiviteit mei de opsje ‘Misbrûk melde’.

Mear ynfo

Dizze konversaasje is argivearre. Stel in nije fraach as jo help nedich hawwe.

No option for email address for import

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??

Keazen oplossing

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.

Dit antwurd yn kontekst lêze 👍 2

Alle antwurden (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 Fraacheigener
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

Keazen oplossing

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 Fraacheigener
more options

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