Mail merge Conditional Bookmark space issue

Is there a way to suppress spacing between two conditional bookmarks, in case the condition does not satisfy the given logic?

 

Eg:  Logic is "Eligible" is yes then print "Description" else blank, so issue is if "Eligible" is no then and it leaves the blank space which needs to be removed.

So how can we create condition which doesn’t leave blank spaces if condition is not applicable? 

 

I am using MS word 2010

Name Eligible Description
India No India (i/ˈɪndiə/), officially the Republic of India (Bhārat Ganarājya),[12][c] is a country in South Asia. It is the seventh-largest country by area, the second-most populous country with over 1.2 billion people, and the most populous democracy in the world. Bounded by the Indian Ocean on the south, the Arabian Sea on the south-west, and the Bay of Bengal on the south-east, it shares land borders with Pakistan to the west;
India Yes Home to the ancient Indus Valley Civilisation and a region of historic trade routes and vast empires, the Indian subcontinent was identified with its commercial and cultural wealth for much of its long history.[13] Four world religions—Hinduism, Buddhism, Jainism, and Sikhism—originated here, whereas Judaism, Zoroastrianism, Christianity, and Islam arrived in the 1st millennium CE and also helped shape the region's diverse culture.
India No The Indian economy is the world's tenth-largest by nominal GDP and third-largest by purchasing power parity (PPP).[14] Followingmarket-based economic reforms in 1991, India became one of the fastest-growing major economies; it is considered a newly industrialised country.

Answer
Answer

Press Alt-F9 to reveal the field codes and turn on the document's formatting marks by clicking on the ¶ symbol on the Ribbon's Home tab. You should now see something like:

{MERGEFIELD Date}¶

Dear ,¶

{IF{MERGEFIELD Eligible}= "Yes" "{MERGEFIELD Description}"}¶

{MERGEFIELD Additional_Verbiage}¶

Yours faithfully¶

ABC¶

Change this to:

{MERGEFIELD Date}¶

Dear ,{IF{MERGEFIELD Eligible}= "Yes" "

{MERGEFIELD Description}"}

¶{MERGEFIELD Additional_Verbiage}¶

Yours faithfully¶

ABC¶

Note how the paragraph break that followed 'Dear,' is now inside the field code. Alternatively, you could use:

{MERGEFIELD Date}¶

Dear ,

{IF{MERGEFIELD Eligible}= "Yes" "{MERGEFIELD Description}


"}{MERGEFIELD Additional_Verbiage}¶

Yours faithfully¶

ABC¶

Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 474 Applies to: