 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / February 2007Problems when exporting from Outlook to Excel
when exporting Contacts from Outlook to an Excel or .csv file I have several problems: there are about 90 fileds for aeach contact and some contacts are missing That is a direct reflection of your Contacts in Outlook. > when exporting Contacts from Outlook to an Excel or .csv file I have > several > problems: there are about 90 fileds for aeach contact and some contacts > are > missing Hi Chuck - whilst I appreciate that the large number of fields probably does reflect my Outlook contacts (in practice I only use about 20 of them - how can I only pick those up - tried fiddling with the match fields, but not succeeded?), this does not explain why contacts which appear in my Outlook Contacts do not appear at all in the exported file, and some of the fields are empty in the exported file which do have data in when in the Outlook Contacts. > That is a direct reflection of your Contacts in Outlook. > > when exporting Contacts from Outlook to an Excel or .csv file I have > > several > > problems: there are about 90 fileds for aeach contact and some contacts > > are > > missing If using the the "default map" Outlook will export 93 fields and not all fields will contain data (i.e. BusinessStreet2, HomeStreet2 etc). Other fields are "derived" so depends on contents of those fields. Lastly, if you have a multi-line field and export to Access/Excel - you may have to expand the field to see full contents if the first line of a multi-line field is blank. You don't mention which fields are empty that contain data so really hard to offer anything else as an answer. Also, are the results the same if you export the same data to a CSV file and open it in a text editor instead of Excel to see exactly what data was exported? To export only the fields you want - simply clear the field map on the right hand side, then drag 'n drop the fields you want to export. Re: missing contacts #1 - can you open these contacts in Outlook individually? #2 - if answer to #1 is yes - suggest running a ScanPst on your PST file to determine if there are any other potential errors in your file. #3 - You are only referring to standard Outlook fields - correct? Outlook doesn't export any custom/user-defined fields. Karl __________________________________________________ ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com > Hi Chuck - whilst I appreciate that the large number of fields probably > does [quoted text clipped - 11 lines] >> > are >> > missing |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.