Avatar for Username

Sök i support

Akta dig för supportbedrägerier: Vi kommer aldrig att be dig att ringa eller skicka ett sms till ett telefonnummer eller dela personlig information. Rapportera misstänkt aktivitet med alternativet "Rapportera missbruk".

Läs mer

Denna tråd har arkiverats. Ställ en ny fråga om du behöver hjälp.

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

Vald lösning

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.

Läs svaret i sitt sammanhang 👍 2

Alla svar (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 Frågans ägare
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

Vald lösning

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 Frågans ägare
more options

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