Merge only if data exists from Access to Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jallen - 26 Dec 2006 13:53 GMT

I would like to know how to merge from Access into a table in Word and that
only rows that had results would show. For example if you had a several
headed rows but on merge only a couple had results then the blank rows would
not show.

I have seen that this can be done when using a data source in Sims.net
called Assessment Manager into Word but I would like to create such a
document for myself from Access to Word thereby avoiding un-necessary blank
rows where results do not exist.

Reply to this Message

Graham Mayor - 26 Dec 2006 14:09 GMT

Use a SKIPIF field to test for content in one of the fields in the record
which may be empty.
Use a conditional field to test for content in individual fields within a
record.
eg
{Mergefield Fieldname1}{IF {Mergefield Fieldname2} <> "" "
{Mergefield Fieldname2}"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I would like to know how to merge from Access into a table in Word
> and that only rows that had results would show. For example if you
[quoted text clipped - 5 lines]
> document for myself from Access to Word thereby avoiding un-necessary
> blank rows where results do not exist.

Reply to this Message

jallen - 26 Dec 2006 14:20 GMT

We found the SKIPIF left a blank line and then carried on underneath thereby
not carrying on continuously with the data to be displayed.

I think that the answer lies specifically in a table in Word and that there
must be advanced code that could get the row to display only if a result was
present otherwise carries on immediately to the next row.

Regards

> Use a SKIPIF field to test for content in one of the fields in the record
> which may be empty.
[quoted text clipped - 13 lines]
> > document for myself from Access to Word thereby avoiding un-necessary
> > blank rows where results do not exist.

Reply to this Message

Doug Robbins - Word MVP - 27 Dec 2006 04:36 GMT

Why not use a Query in Access to filter out the unwanted records and then
use that Query as the data source for the mail merge?

Signature

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

> We found the SKIPIF left a blank line and then carried on underneath
> thereby
[quoted text clipped - 25 lines]
>> > document for myself from Access to Word thereby avoiding un-necessary
>> > blank rows where results do not exist.

Reply to this Message

Rate this thread: