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 / January 2005

Tip: Looking for answers? Try searching our database.

Word 2002 - erratic merge selections after changing label size

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lionel Kremer - 21 Jan 2005 23:38 GMT
I have been operating an Access 2 customer database successfully for 11 years, initially with Word 2, then W95 and now W2002 under XP (SP2).

My 'standard letters' (with customised wording depending on if>then>else clauses) continue to work well when customers are selected by whatever criteria I specify.  

My 'merge-selected-customers-to-sheeted-labels' document works *fine* with A4 size 14-label sheets but, after trying many times, via several routes, to replicate thie for 21-label sheets I get one of the following erratic outcomes, each consistent for a specific new merge document:

a) the 'set query options' step in the mailmerge helper does not take effect and loses its criteria after saving, so that *all* customers get labels

b) the *first* customer (even though not specified in query options) plus the *last* customer fulfilling the selection criteria

c) it displays a label for the *first* and *last* of the customers fulfilling the selection criteria but not the intervening ones

I repeat - the 14-label document (now saved as a current-version Word doc) *always* displays the *correct* customer selection (so please don't criticise my Access 2 database!) but whichever approach I use to replicate it for 21-label sheets results in erratic selection of customer records!

Is this a known bug and is there a fix or work-around, please?
Lionel Kremer - 23 Jan 2005 00:27 GMT
Replying to my own cry for help!  I've done it, tho' may not be able to explain to others who are having problem with printing selected labels from an (old) Access database.  I'll try, if you contact me via this site.
 
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.