Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2018, 04:22 PM
macropod's Avatar
macropod macropod is offline Mail merge: remove empty rows when a field is not showed Windows 7 64bit Mail merge: remove empty rows when a field is not showed Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
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

If you need to skip entire labels, you should apply a mailmerge filter with the required criteria, which you do via Mailings|Edit Recipient List>Filter.



As for the field coding I described, see the attached.
Attached Files
File Type: docx MailMerge Main Document.docx (17.3 KB, 66 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 09-23-2018, 12:17 AM
Yarikh Yarikh is offline Mail merge: remove empty rows when a field is not showed Windows 10 Mail merge: remove empty rows when a field is not showed Office 2016
Novice
Mail merge: remove empty rows when a field is not showed
 
Join Date: Jan 2018
Posts: 6
Yarikh is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
If you need to skip entire labels, you should apply a mailmerge filter with the required criteria, which you do via Mailings|Edit Recipient List>Filter.

As for the field coding I described, see the attached.
Oh my!
Thanks, thanks, thanks! The solution was quite obvious, after all...

I was doing wrong because I was leaving the line break after the fields instead of deleting it and writing them right after the previous.

So I was writing:
{IF{MERGEFIELD Titolo}<> "" "{MERGEFIELD Titolo}¶
"}
{IF{MERGEFIELD Contenuto...


Instead f:
{IF{MERGEFIELD Titolo}<> "" "{MERGEFIELD Titolo}¶
"}{IF{MERGEFIELD Contenuto...


No comment please.

I just used the same trick also for the "Vecchia segnatura" and "Note alla vecchia segnatura", and everything was perfect.

Thanks again!
Reply With Quote
Reply

Tags
if rule, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge: remove empty rows when a field is not showed creating badges using mail merge and do not want to supress lines with empty fields johnmorabito Mail Merge 1 04-25-2018 02:33 PM
Mail merge: remove empty rows when a field is not showed Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 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 Empty Data Field Licos101 Mail Merge 2 04-10-2014 06:19 AM
Mail merge: remove empty rows when a field is not showed How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 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