Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supressing Lines (Word)

Status
Not open for further replies.

ncooley

Programmer
Sep 29, 2004
5
GB
Hello

How do you supress lines if the are blank in Word 2003. I am mail merging from Goldmine using DDEAuto but within the address fields there are blanks, is there any easy way to blank those lines in Word

Neil
 
Hi Neil,

If I understand your problem correctly, you data source has empty fields in some records, and you want to suppress the blank lines that these generate in your mailmerge.

Suppose you have a MERGEFIELD that inserts the name of a company if the addressee has provided company details, but not all addressees have done this. Your MERGEFIELDs might look like:
{MERGEFIELD Name}
{MERGEFIELD Company}
{MERGEFIELD Address}

To suppress the 'Company' line when it's empty, change your MERGEFIELDS to:
{MERGEFIELD Name}
{IF{MERGEFIELD Company}= "" "" "{MERGEFIELD Company}
"}{MERGEFIELD Address}
Note the line-feed/carriage return in the '"{MERGEFIELD Company}
"}' string.

Cheers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top