Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-02-2015, 01:48 PM
loulourose loulourose is offline Contacts Excel 2013 to Outlook 2013 Windows 10 Contacts Excel 2013 to Outlook 2013 Office 2013
Novice
Contacts Excel 2013 to Outlook 2013
 
Join Date: Sep 2015
Posts: 1
loulourose is on a distinguished road
Exclamation 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!
Attached Images
File Type: png Untitled picture.png (14.0 KB, 14 views)
Reply With Quote
  #2  
Old 09-02-2015, 09:10 PM
gmayor's Avatar
gmayor gmayor is offline Contacts Excel 2013 to Outlook 2013 Windows 7 64bit Contacts Excel 2013 to Outlook 2013 Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 03-07-2016, 03:32 AM
dvnjnc57 dvnjnc57 is offline Contacts Excel 2013 to Outlook 2013 Windows 10 Contacts Excel 2013 to Outlook 2013 Office 2013
Novice
 
Join Date: Mar 2016
Location: Belgium
Posts: 1
dvnjnc57 is on a distinguished road
Default 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 ?
Reply With Quote
Reply

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
Contacts Excel 2013 to Outlook 2013 Importing Contacts into Outlook 2013 rtwcs Outlook 1 02-18-2015 03:09 AM
Contacts Excel 2013 to Outlook 2013 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
Contacts Excel 2013 to Outlook 2013 Outlook 2013 Contacts Disappear abraxis Outlook 5 06-03-2014 07:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft