Conditional mail merge formatting: ONLY include blank cells

Question

Hi,

I've searched high and low for an answer to this - I'd be very grateful for your help.

I'm creating a Word mail merge letter using data from an excel spreadsheet. I have information of over 400 people that I'm looking to email.

I'm notifying these people of which pieces of personal information we are missing from them (for example address, mobile number etc...). And so I need to create a rule for the mail merge to only pull cells from the spreadsheet that are blank.

Would anyone know how I can use the 'if...then...else' rule to create a phrase along the lines of:

<<IF MERGEFIELD DOB = NOT blank = "Information Received">>?

OR

to ONLY input the data if it is blank? If this is possible?

Any help is much appreciated - thanks in advance.

Answer 1

Hi @Nina,

Did you need this rule?

<<IF MERGEFIELD DOB<>"" "Information Received">>

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.