Mail merge- Formatting Issue
Thank you for the help.
I am using a basic mail merge from an excel document to a word template to create a letter. My merge uses about 10 fields successfully with no issues. I attempted to add two additional fields and have ran into some issues. Both fields use numbers. Examples would be Number 1= "2806426" but when merged into Word it is giving me "9/24/9583" The second filed example would be "104513-860390" and in word it is giving me "12:00:00 AM".
I have changed the excel format trying "general" and "text" to format the cells with no changes to final merge field.
I have also tried to merge the field at the end of the document to see if the Word document was completing the formatting on its end but I receive the same value no matter where I place the merge field.
I have other number merges that work just fine.
Any suggestions would be much appreciated.
|