#1
|
|||
|
|||
Contacts Excel 2013 to Outlook 2013
Hello,
I cannot somehow export contacts from excel 2013 to Outlook 2013. 1) I have done everything 2) Clearly identify my fields on each columns 3)Save my sheet as a Text delimited 4) Use it as a CSV Where I have trouble is that Outlook does not somehow recognize my field and finds other field. To have a better understanding here is a screenshoot of my problem. Thanks for your help and pretty desperate! |
#2
|
||||
|
||||
You need to save your worksheet as CSV(Comma Delimited) to create a comma delimited file, which should look like
PROP_ID,OWNER,E-MAIL,ADDR_LINE1,ADDR_CITY,ADDR_STATE,ADDR_ZIP,LEGA L_DESC,ACRES,VALUE 174644,Acord Charles,,,Anytown,XY,15948,Abst 1088 T S Fitch Svy 281.1 Tr 2,7.11,"$3,555.00" 157357,Acosta John A,,P O Box 509,Sometown,XY,45612,Yahoo Oaks Ranch Blk 1 Lt 15,1.51,$755.00
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Imports into Outlook 2013
Once again Microsoft missed the point ! In earlier versions up to 2010, it was easy to import data into Outlook. They had a perfect wizard to do the job. Now (and God only knows why but I'm not sure He does ) you have to use .CSV files to import data. And when I say Csv I mean it. If like most European users, your Windows uses a semi-column ';' to separate data, it won't work. You must first change Windows settings in Regional settings and use the comma ',' to enable Outlook correct import.
Then and only then will it work properly. Why did Microsoft forsake that wizard ? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Contacts Folder is empty in Outlook 2013 | rray6 | Outlook | 0 | 03-06-2015 08:22 PM |
Importing Contacts into Outlook 2013 | rtwcs | Outlook | 1 | 02-18-2015 03:09 AM |
importing a .CSV Contacts file from Excel to Outlook 2013, | mahfoudhhi | Outlook | 9 | 09-21-2014 05:25 AM |
Import Contacts to Outlook 2013 | thethinker | Outlook | 0 | 08-12-2014 08:30 AM |
Outlook 2013 Contacts Disappear | abraxis | Outlook | 5 | 06-03-2014 07:38 AM |