Merge only if data exists from Access to Word

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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

 

[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

 

[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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article:

http://support.microsoft.com/default.aspx?scid=kb;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