[Diddy]

Hi,

I'm trying to set up a packing list mail merge. I've got 9 items in total,
some record will have all items and some just a few. My data source is an
Excel workbook.

What I would like is to set up a table containing the fields but if the
field contains a zero then the table row should not appear.

Any help or suggestions would be brilliant!

Cheers

[Doug Robbins - Word MVP]

Are there nine separate fields, some of which may be blank, or are there up
to nine records that make up the one packing list?

If the latter, check out fellow MVP Macropod's Word 97-2007
Catalogue/Directory Mailmerge
Tutorial at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it.

If the former, there is really no way to do this with mail merge alone. You
would have to run a macro after executing the merge to delete rows from the
table where there was no information in the particular cell that was blank.
Alternatively, a "roll-your-own" VBA based equivalent to mail merge.


--
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, originally posted via msnews.microsoft.com
"Diddy" wrote in message
...
Hi,

I'm trying to set up a packing list mail merge. I've got 9 items in
total,
some record will have all items and some just a few. My data source is an
Excel workbook.

What I would like is to set up a table containing the fields but if the
field contains a zero then the table row should not appear.

Any help or suggestions would be brilliant!

Cheers

[Diddy]

Thank you Doug,

The links were really helpful, not all done yet but nearly there

Cheers
Diddy

"Doug Robbins - Word MVP" wrote:

Are there nine separate fields, some of which may be blank, or are there up
to nine records that make up the one packing list?

If the latter, check out fellow MVP Macropod's Word 97-2007
Catalogue/Directory Mailmerge
Tutorial at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it.

If the former, there is really no way to do this with mail merge alone. You
would have to run a macro after executing the merge to delete rows from the
table where there was no information in the particular cell that was blank.
Alternatively, a "roll-your-own" VBA based equivalent to mail merge.


--
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, originally posted via msnews.microsoft.com
"Diddy" wrote in message
...
Hi,

I'm trying to set up a packing list mail merge. I've got 9 items in
total,
some record will have all items and some just a few. My data source is an
Excel workbook.

What I would like is to set up a table containing the fields but if the
field contains a zero then the table row should not appear.

Any help or suggestions would be brilliant!

Cheers