Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2022, 06:17 AM
jnbradl jnbradl is offline Mail merge- Formatting Issue Windows 11 Mail merge- Formatting Issue Office 2021
Novice
Mail merge- Formatting Issue
 
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
  #2  
Old 09-08-2022, 02:37 PM
macropod's Avatar
macropod macropod is offline Mail merge- Formatting Issue Windows 10 Mail merge- Formatting Issue Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your problem suggests you have mixed data types in the columns concerned. See the Mailmerge Data Format Problems topic in the Mailmerge Tips & Tricks thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 09-09-2022, 05:18 AM
jnbradl jnbradl is offline Mail merge- Formatting Issue Windows 11 Mail merge- Formatting Issue Office 2021
Novice
Mail merge- Formatting Issue
 
Join Date: Sep 2022
Posts: 2
jnbradl is on a distinguished road
Default

Thank you. This was more than informative. For anyone looking in the future, my issue was caused by hidden rows. This is a working sheet with hundreds of rows and we only sort the ones that are currently being worked on. When I added the two columns and selected the format as "general" or "text" somehow it was not formatting row one. Once I expanded and showed all rows I was able to see that row 1 was still formatted as "date". Once that was changed to general all merged as it should.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Many to One Mail Merge Issue Frenchie_King757 Mail Merge 2 07-02-2021 05:33 AM
Mail Merge Suppression issue gizmo83 Mail Merge 4 07-12-2019 12:08 AM
Mail merge- Formatting Issue Mail Merge Code Issue Andrewwill Mail Merge 6 01-06-2018 10:25 PM
Mail Merge Formatting Issue with Conditional IFs robbeh Mail Merge 5 07-08-2014 07:39 AM
Mail merge- Formatting Issue Office 2007 Mail Merge Issue - automatic formatting and revisions balloons sharpie21 Office 1 10-10-2010 03:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft