Thread: [Solved] Mail merge- Formatting Issue
View Single Post
 
Old 09-08-2022, 06:17 AM
jnbradl jnbradl is offline Windows 11 Office 2021
Novice
 
Join Date: Sep 2022
Posts: 2
jnbradl is on a distinguished road
Default 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.
Reply With Quote