I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted street names. (ie. 77 1st Avenue)
When we do the merge, the formatting is lost. (ie. 77 1st Avenue) The formatting was preserved in Office 2003 without an issue. The same loss of formatting occurs when Excel 2010 is used as the source document.
Is there a switch that needs to be set? In the field properties, I selected "Preserve formatting during updates", but no luck.
Update: I found an article on Microsoft's support site, discussing a similar loss of formatting during mail merges.
It suggests using Dynamic Data Exchange. Unfortunately, I could not get a link to work with an Excel 2010 document. I was able to link from Word 2010 to an older XLS document, but still, the formatting was lost.