Suppress Blank Rows in Table in Access Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lyn - 26 Jun 2004 10:17 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 28 Jun 2004 14:01 GMT

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

:-)

Reply to this Message