Suppress Blank Rows in Table in Access Mail Merge

[Lyn]

I have inserted mergefields from Access in rows in a Word
Table. If the fields in Access are blank, I would like
for the row on the table to be suppressed. What would you
suggest?

 

[Cindy M -WordMVP-]

Hi Lyn,

I have inserted mergefields from Access in rows in a Word
Table. If the fields in Access are blank, I would like
for the row on the table to be suppressed. What would you
suggest?

Using a DATABASE field instead of mail merge to link the
data into Word. And set up a query in Access that suppresses
the records causing the blank rows.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail