Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2025, 05:01 PM
macropod's Avatar
macropod macropod is offline Mail Merge Outputs one Row with the Field Names Windows 10 Mail Merge Outputs one Row with the Field Names Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,526
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


You're getting the extra rows because you aren't testing whether the 'observation' field is empty before outputting both the header rows and the empty 'observation' data.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 06-30-2025, 11:41 PM
Barattolo_67 Barattolo_67 is offline Mail Merge Outputs one Row with the Field Names Windows 11 Mail Merge Outputs one Row with the Field Names Office 2021
Novice
Mail Merge Outputs one Row with the Field Names
 
Join Date: Jan 2022
Posts: 5
Barattolo_67 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You're getting the extra rows because you aren't testing whether the 'observation' field is empty before outputting both the header rows and the empty 'observation' data.
Thank you for your reply. I’m not sure I understand in full what I should do to fix the issue.

Thank you and best regards.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel/Word Mail Merge - Same Address...different names/Rows doucecool67 Mail Merge 1 05-31-2019 03:37 PM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Mail merge with Duplicate Names but Different Dollar Amounts bh24524 Mail Merge 27 03-24-2014 01:15 PM
Mail Merge Outputs one Row with the Field Names How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Mail Merge Outputs one Row with the Field Names Mail merge with names in content richard82 Mail Merge 1 07-07-2011 11:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:42 AM.


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