New User - Simple mail merge question?

  • Thread starter Thread starter KevinM
  • Start date Start date
K

KevinM

I have been successfully using mail merge in a basic way for some time,
however I thought I would try and be a bit smarter and now I am stuck!

I am merging salary letters, however certain benefits to not apply to
all employees. Eg Car Allowance. So in Excel I have a spreadheet
showing
Salary Car Allowance
B Smith 10,000 3,000
S Jones 15,000 0

In Word I have a letter with the following merge fields eg

I am pleased to confirm your salary as <<salary>>
and your car allowance will remain as <<car allowance>>

What I would like to do is only add the second line relating to car
allowance if the allowance shown in Excel is greater than zero.

Can anyone help - I have tried the help pages and looked at the FAQs
but I cannot seem to find a simple answer - Thanks?
 
Replies to the same question in the mailmerge.fields
newsgroup have already been posted.

Cindy Meister
 
Back
Top