Removing Blank Fields from a mail merge using Word

  SavonX 11:50 23 Jul 2008
Locked

I am using Word 2003 to create a mail merge, the data source is a excel 2003 document. I only want to show fields that contain data when the merge is complete is this possible?

i.e

Main document fields

Name:
DOB:
Sex:

Record in data Source

Name: Mr X
DOB: 01/01/04
Sex:

Main Document after Mail Merge

Name: Mr X
DOB: 01/01/04

  recap 12:03 23 Jul 2008

When in Word on the Mail Merge toolbar select 'Mail Merge Recipients'. You should be presented with the list of fileds, just take the tick out of the field you do not require.

  nosharpe 12:10 23 Jul 2008

You need to search on Google for "If Else" queries - there should be a handful of useful specialist websites out there.
Failing that, look on Word help (F1) and search for "If else"

  SavonX 12:24 23 Jul 2008

recap - if i change the drop downs on the fields to non blanks it gets rid of the whole record not just the fiels

thanks anyway

  recap 13:14 23 Jul 2008

Not too sure if this is what you are meaning SavonX

click here

  Taff™ 13:26 23 Jul 2008

Try Inserting a Word Field using the icon nect to Insert Merge Field. Choose If Then Else. Drop the box next to the field name "Name" and select "Is Not Blank", type in the box below "Name: " - No quotes and a space after the semi colon. Leave the botom box blank or perhaps type "Unknown"

Repeat for each of the other fields.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone