Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2014, 10:49 AM
blademaster blademaster is offline Outlook 2010 Windows 7 64bit Outlook 2010 Office 2010 64bit
Novice
Outlook 2010
 
Join Date: Dec 2014
Posts: 3
blademaster is on a distinguished road
Cool Outlook 2010

Has anyone come across a problem whereby after exporting contacts to a csv file, most cells have a hidden a hidden question mark (?) therefore I am unable to run a dedupe because excel is unable to find matching records because of this.



Any ideas would be great?

Thank you
Reply With Quote
  #2  
Old 12-10-2014, 01:50 AM
GerryLu GerryLu is offline Outlook 2010 Windows 7 32bit Outlook 2010 Office 2010 32bit
Banned
 
Join Date: Nov 2014
Posts: 12
GerryLu is on a distinguished road
Default

Is there any options to select when you export your contacts to csv? this seems a character encoding problem, try to save the file as "UTF8"
Reply With Quote
  #3  
Old 12-11-2014, 07:47 AM
blademaster blademaster is offline Outlook 2010 Windows 7 64bit Outlook 2010 Office 2010 64bit
Novice
Outlook 2010
 
Join Date: Dec 2014
Posts: 3
blademaster is on a distinguished road
Default

Unfortunately the options available are as attached.

Thank you for your help

Merry Christmas
Attached Images
File Type: png Capture.PNG (33.2 KB, 14 views)
Reply With Quote
  #4  
Old 12-12-2014, 02:18 AM
GerryLu GerryLu is offline Outlook 2010 Windows 7 32bit Outlook 2010 Office 2010 32bit
Banned
 
Join Date: Nov 2014
Posts: 12
GerryLu is on a distinguished road
Default

Quote:
Originally Posted by blademaster View Post
Unfortunately the options available are as attached.

Thank you for your help

Merry Christmas
Which option did you choose? i think you should choose the second one
BTW, does your contact contains character other than English?
Reply With Quote
  #5  
Old 12-15-2014, 04:30 AM
blademaster blademaster is offline Outlook 2010 Windows 7 64bit Outlook 2010 Office 2010 64bit
Novice
Outlook 2010
 
Join Date: Dec 2014
Posts: 3
blademaster is on a distinguished road
Default

Hi

I have tried all combinations without success however I do now have a error free spreadsheet! I did this by exporting data to Access, then back to Excel. Pain the as* but it worked
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2010 Trying to import a calender into a custom calendar from Excel 2010 into Outlook 2010 stevecraig2014 Outlook 4 09-22-2014 07:31 AM
Copy Outlook 2007 "AutoComplete Contacts” to Outlook 2010 zillah Outlook 0 09-13-2013 08:37 PM
Sync Outlook 2010 contacts, calendar & tasks with Outlook.com & Windows Mobile 8 TimTDP Outlook 0 01-04-2013 11:30 PM
How di save additional mailboxes when upgrading from outlook 2007 to outlook 2010? Dayo Outlook 0 06-25-2012 04:13 AM
Outlook 2010 Open an outlook 2003 pst data-file from inside outlook 2010 pinholt Outlook 2 11-10-2010 07:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 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