Exporting Data from Outlook Notes Field - Getting truncated - Need way to export all

I am working on a complex export from Outlook 2010.  Over 11+ years the user has made extensive use of the big open notes field in the vcard.  It has all kinds of data in it, pasted emails, images, account numbers, birthdays, etc.  When the data was exported out, I noticed that the notes field data from Outlook was truncated.

Does anyone have any experience with this and a workaround to get all the data out of that field?

On the export, Outlook calls the field "notes1", I am trying to bring all that data over (knowing the pasted images and likely other things are not coming, too) into a legacy notes field into a popular CRM for the user.

Thank you for any help you may be able to provide, Bullit2

January 23rd, 2015 1:15am

Tried to upload a screenshot of a sample vcard with the notes field jam packed with data but apparently my account / email has not been verified by this board???

If make it to verified status, will post screen shot of vcard full of data in notes field.

Thanks, Bullit2

Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2015 1:17am

Does anyone have any experience with this and a workaround to get all the data out of that field?

On the export, Outlook calls the field "notes1", I am trying to bring all that data over (knowing the pasted images and likely other things are not coming, too) into a legacy notes field into a popular CRM for the user

#1 - Just how large are these Notes fields? Exporting to a CSV file should result in the complete Notes field being exported without any links, images etc. Am not sure what, if any upper limit there is on the <Notes> field but tested it with one in excess of 69K of data successfully re-importing the same file with all data getting included.

#2 - A little puzzled about how the Notes field is labeled as <Notes1> on export - not something I've ever seen using the Outlook export wizard

#3 - What exactly are you referring to with "the user has made extensive use of the big open notes field in the vcard" - by vcard do you mean the Outlook contact detail screen?

Unless your customer is using custom fields - then the Outlook export wizard is all that you're going to need

January 23rd, 2015 5:07am

You can try to use the free Export Contacts to vCard utility. No issues with large notes were fo
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2015 6:19pm

Thank you so much, reexported to csv, and all notes came out, we think when we moved / saved the .csv file into excel that is when the truncation happened and the notes got cut off.  All the best, 
February 3rd, 2015 3:50pm

Thank you so much, reexported to csv, and all notes came out, we think when we moved / saved the .csv file into excel that is when the truncation happened and the notes got cut off.  All the best, 

Yes, saving as excel format will cause problems due to limitation on the side of the cell and due to formatting issues - notes get broken into chunks and pushed into new records.
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2015 4:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics