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
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
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
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.