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 / February 2008

Tip: Looking for answers? Try searching our database.

WORD/EXCEL LABEL MAILMERGE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Monte - 07 Feb 2008 16:35 GMT
I have done this many times before. Now when I select my receipients from the
spreadsheet the program imports the ENTIRE list. I used to be able to cut and
paste the section I wanted, now it says it is too large. The Excel file is a
read only, can that be the problem?

Please help, I am going crazy.
Graham Mayor - 08 Feb 2008 08:37 GMT
From your description it is difficult to guess what you are doing. See where
what you are doing differs from
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

Signature

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

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

> I have done this many times before. Now when I select my recipients
> from the spreadsheet the program imports the ENTIRE list. I used to
> be able to cut and paste the section I wanted, now it says it is too
> large. The Excel file is a read only, can that be the problem?
>
> Please help, I am going crazy.
Monte - 08 Feb 2008 14:35 GMT
Thanks Graham. This still does not work. When I select only a few of them on
the list it still sets up all of them. I clear all, them check the few I want
and replicate,then complete the merge and VOILA, I get all 19,000...

> From your description it is difficult to guess what you are doing. See where
> what you are doing differs from
[quoted text clipped - 7 lines]
> >
> > Please help, I am going crazy.
Peter Jamieson - 08 Feb 2008 18:26 GMT
My reply to a similar question last year:

<<
As far as I can tell, this will occur if you havemore than 10,000 records in
your data source and you are trying to select individual records in the
MailMerge Recipients Dialog Box, which can only contain 10,000. 9999 records
and you seem to be OK. Of course, some other factor may be at work as well.

The 10,000 limit is AFAIK undocumented by Microsoft. Actually, people have
mentioned similar problems before and I, for one, have never connected this
particular problem to that particular limit. But if it is the 10,000 limit,
you could try submitting a support incident, but I wouldn't hold your breath
for a solution. Personally, I would have thought that a limit that at least
accommodated the maximum number of rows in an Excel 2003 sheet would help a
lot of people and would not cause problems for present-day PCs.

The only other suggestions I can make are
a. apply query conditions /before/ making your selections, but there can be
problems in that area as well.
b. consider the possibility that when you reachthe 10,000 limit, you're in
the territory where MS is pushing you to do things in a different way. Sad
if that's the case but perhaps a nasty reality.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Thanks Graham. This still does not work. When I select only a few of them
> on
[quoted text clipped - 14 lines]
>> >
>> > Please help, I am going crazy.
 
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.