[[email protected]]

I am creating mail merge letters (pay-slips) in Word 2003 from a list
of about 300 employee records in Excel.

The list has 28 fields and some of the values in some of the fields in
the workbook are blank or zero.

What I need is that, when a value is blank or zero, then that field
(both field name and value) dosen't show at all on the letter so as to
make each pay slip contain only data that is non-zero and therefore
relevant to its recipient. E.g. if the 'Overtime' field for a record is
blank/zero (meaning this employee does ont receive overtime) then that
field doesnt even show on the letter.

In the letter, each filed is in its own row in a table. I've tried
using the "IF...Then...Else" condition for mail merge but it leaves a
space in the row when a field is blank/zero resulting in too may empty
rows in the letter.

I'm looking for a solution to taking only the fields I want from the
Excel sheet. Also, If there's a way to to automatically remove the
empty rows in the table when they're blank I'd finish of the solution
I'd started. Hope this makes sense.


Thanks in advance

[Doug Robbins - Word MVP]

See response in vba.beginners newsgroup. Please do not post the same
question separately to multiple newsgroups.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

wrote in message
oups.com...
I am creating mail merge letters (pay-slips) in Word 2003 from a list
of about 300 employee records in Excel.

The list has 28 fields and some of the values in some of the fields in
the workbook are blank or zero.

What I need is that, when a value is blank or zero, then that field
(both field name and value) dosen't show at all on the letter so as to
make each pay slip contain only data that is non-zero and therefore
relevant to its recipient. E.g. if the 'Overtime' field for a record is
blank/zero (meaning this employee does ont receive overtime) then that
field doesnt even show on the letter.

In the letter, each filed is in its own row in a table. I've tried
using the "IF...Then...Else" condition for mail merge but it leaves a
space in the row when a field is blank/zero resulting in too may empty
rows in the letter.

I'm looking for a solution to taking only the fields I want from the
Excel sheet. Also, If there's a way to to automatically remove the
empty rows in the table when they're blank I'd finish of the solution
I'd started. Hope this makes sense.


Thanks in advance