Problems filtering data

[Tony C]

I have just loaded Office 2003 and I am using documents
and databases created with a previous version. When I try
to filter records to merge a portion of the database, Word
shows the selected addresses correctly in the filtering
box, but does not limit the document to that sample when
merging - so I get the full database printed.

Setting up a query in Access only allows one filter to be
saved, not several.

Any ideas for correcting this? The older version of Office
seems superior in handling merge data, but maybe I'm doing
it wrong.

 

[Graham Mayor]

You can still use the old method - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
Treat Access as Excel when reading this page.

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Cindy M -WordMVP-]

Hi Tony,

Running a quick test, just to make sure my memory serves...

I can't duplicate the problem. If I set up a merge to an
Access database, then use the Recipients dialog box to filter
the records (from the column header drop-down) to select only
those who meet a particular criterium, only those records are
merged.

Can you give us more details on how you're selected the
records? Besides the steps, what kind of data is it: numeric,
date, textual...

Also, is this an older main merge document, or a newly
created one? If the latter, is it from a Normal.dot you've
brought forward across versions of word, or a relatively new
copy, generated from Word 2003? (I'm considering whether
damage in the document structures might be playing a role,
here)

I have just loaded Office 2003 and I am using documents
and databases created with a previous version. When I try
to filter records to merge a portion of the database, Word
shows the selected addresses correctly in the filtering
box, but does not limit the document to that sample when
merging - so I get the full database printed.

Setting up a query in Access only allows one filter to be
saved, not several.

Any ideas for correcting this? The older version of Office
seems superior in handling merge data, but maybe I'm doing
it wrong.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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