Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2004

Tip: Looking for answers? Try searching our database.

Problems filtering data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony C - 13 May 2004 17:15 GMT
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 - 13 May 2004 17:29 GMT
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.

Signature

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

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

> I have just loaded Office 2003 and I am using documents
> and databases created with a previous version. When I try
[quoted text clipped - 9 lines]
> seems superior in handling merge data, but maybe I'm doing
> it wrong.
Cindy M  -WordMVP- - 15 May 2004 12:58 GMT
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
[quoted text clipped - 9 lines]
> 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 :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.