Mail merge: remove empty rows when a field is not showed

Yarikh · #3 09-22-2018, 08:55 AM

Quote:

Originally Posted by macropod

Instead of:
{ IF { MERGEFIELD Titolo }<> "" "{ MERGEFIELD Titolo }" "" }¶
use:
{MERGEFIELD Titolo \f "¶
"}
where ¶ is the actual paragraph break. Do the same with { MERGEFIELD Contenuto }

Similarly, instead of:
{ IF { MERGEFIELD Note_alla_datazione }<> "" "Note alla datazione: { MERGEFIELD Note_alla_datazione }" "" }¶
use:
{ IF { MERGEFIELD Note_alla_datazione }<> "" "Note alla datazione: { MERGEFIELD Note_alla_datazione }¶
"}

This is all discussed in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

I'm sorry, maybe I'm really dumb, but I don't understand.

I tried to follow what you wrote and also read the tips&tricks topic, but I cant' obtain what I need: things remain the same, or worse, I create one more break line.

I think my problem is I need to use labels (which have to disappear when the field is ampty) and IF rules all toghether.

Can you explain better what I have to do or even better give me the correct version of my template?

Thanks so much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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
How to ignore a mail merge field if the field is blank	redzan	Mail Merge	1	05-16-2013 08:34 AM