[jallen]

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.

[Graham Mayor]

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}"}


--

Graham Mayor - Word MVP

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




jallen wrote:
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.

[jallen]

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

"Graham Mayor" wrote:

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}"}


--

Graham Mayor - Word MVP

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




jallen wrote:
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.

[Doug Robbins - Word MVP]

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?

--
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

"jallen" wrote in message
...
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

"Graham Mayor" wrote:

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}"}


--

Graham Mayor - Word MVP

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




jallen wrote:
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.

[jallen]

The query would not work as the data changes for each recipient and that is
why I need it to ignore a field if not data exists for that field, but that
would not be the same for each recipient of the merged document.

Thanks for the reply though and any more thoughts from anyone would be of
great help.

"Doug Robbins - Word MVP" wrote:

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?

--
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

"jallen" wrote in message
...
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

"Graham Mayor" wrote:

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}"}


--

Graham Mayor - Word MVP

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




jallen wrote:
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.

[Doug Robbins - Word MVP]

In that case, I would do it all in Access with a Report rather than using
Word as it sounds like you are trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do. However, for ways in which it might be done in Word, see the
"Group Multiple items for a single condition" item on fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default...b;en-us;211303

--
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

"jallen" wrote in message
...
The query would not work as the data changes for each recipient and that
is
why I need it to ignore a field if not data exists for that field, but
that
would not be the same for each recipient of the merged document.

Thanks for the reply though and any more thoughts from anyone would be of
great help.

"Doug Robbins - Word MVP" wrote:

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?

--
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

"jallen" wrote in message
...
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

"Graham Mayor" wrote:

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}"}


--

Graham Mayor - Word MVP

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




jallen wrote:
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.