View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
cpeiner cpeiner is offline
external usenet poster
 
Posts: 3
Default Delete text precending an empty/zeroed merge field?

I hav created a number of documents which include up to 3 profit ranges,
such as this:

From «Start_Range_1» to «End_Range_1» = «Percentage_1»
From «Start_Range_2» to «End_Range_2» = «Percentage_2»
From «Start_Range_3» to «End_Range_3» = «Percentage_3»

In many cases only one or two ranges are used, leaving the other
ranges/percentages empty, which generates the following result:

From £2,000,000 to £3,000,000 = 1.00%
From £3,000,000 to £6,000,000 = 0.50%
From £ 0 to £ 0 0.00% = 0.00%

Is there a way to make Word delete the preceding text when the next field is
emply? I'm fairly new to MailMerge, so I don't know much about IF functions
outside of Excel.

Any help is greatly appreciated. Cheers!