If...then...Else... is the only way to do it, but you are not going to be
able to have the fields in a table if you do not want blank rows in that
table.
What you will probably need is to use nested If...then...Else... fields in
which the negative result for the first field that you check contains an
If...then...Else... that checks the existence of data in the next field,
etc.
--
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
<limbikani[ at ]gmail.com> wrote in message
news:1153057993.954331.78840[ at ]b28g2000cwb.googlegroups.com...
[Quoted Text] >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 in VBA to remove the empty rows in
> the table when they're blank I'd finish of the solution I'd started.
> Hope this makes sense.
>
|