Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Brendan K Brendan K is offline
external usenet poster
 
Posts: 1
Default Limit of 10,000 records on recipient list in Word 2007

HI
I have a mail merge data source that is in Excel, and the number of records
in the excel sheet is greater than 10,000. When I am doiung my mail merge in
Word, I go to the option 'Edit Recipients' , and deselect some of the records
fomr the mail merger. I then exit the 'Edit Recipients' option, and go back
in again to make sure my selection has been saved
When teh number of records in my source is less than 10,000 , it will
besaved OK, when more it will not be saved.
Is there a way that I can increase this 10,000 limit?
Thanks
Brendan
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Limit of 10,000 records on recipient list in Word 2007

Is there a way that I can increase this 10,000 limit?

Not as far as I know.

The other main options are probably:
a. have a column in Excel that allows you to mark the records that you
want ( or do not want) using Excel (e.g. with a "N" if you don't want
them) and use a filter in Word to retrieve the records that you do want
b. split up your data source in some way to make it more manageable as
far as selections are concerned. But in that case, you will probably
have to do multiple merges, so (a) is probaby your best bet if it is
feasible for you.

Peter Jamieson

http://tips.pjmsn.me.uk

On 27/04/2010 11:32, Brendan K wrote:
HI
I have a mail merge data source that is in Excel, and the number of records
in the excel sheet is greater than 10,000. When I am doiung my mail merge in
Word, I go to the option 'Edit Recipients' , and deselect some of the records
fomr the mail merger. I then exit the 'Edit Recipients' option, and go back
in again to make sure my selection has been saved
When teh number of records in my source is less than 10,000 , it will
besaved OK, when more it will not be saved.
Is there a way that I can increase this 10,000 limit?
Thanks
Brendan

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Brendan K[_2_] Brendan K[_2_] is offline
external usenet poster
 
Posts: 1
Default Limit of 10,000 records on recipient list in Word 2007

Thanks Peter
That was what I thought also, good to get somebody else view /opinion.
Thanks again

"Peter Jamieson" wrote:

Is there a way that I can increase this 10,000 limit?


Not as far as I know.

The other main options are probably:
a. have a column in Excel that allows you to mark the records that you
want ( or do not want) using Excel (e.g. with a "N" if you don't want
them) and use a filter in Word to retrieve the records that you do want
b. split up your data source in some way to make it more manageable as
far as selections are concerned. But in that case, you will probably
have to do multiple merges, so (a) is probaby your best bet if it is
feasible for you.

Peter Jamieson

http://tips.pjmsn.me.uk

On 27/04/2010 11:32, Brendan K wrote:
HI
I have a mail merge data source that is in Excel, and the number of records
in the excel sheet is greater than 10,000. When I am doiung my mail merge in
Word, I go to the option 'Edit Recipients' , and deselect some of the records
fomr the mail merger. I then exit the 'Edit Recipients' option, and go back
in again to make sure my selection has been saved
When teh number of records in my source is less than 10,000 , it will
besaved OK, when more it will not be saved.
Is there a way that I can increase this 10,000 limit?
Thanks
Brendan

.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Recent Docs list in Word 2007--limit to #s? Paul Microsoft Word Help 3 February 20th 09 03:15 PM
Editing Mail Merge Recipient List in Word 2007 Nat Microsoft Word Help 1 May 1st 08 06:48 AM
Recipient List in Word 2007 Teresita Mailmerge 1 March 13th 08 09:54 PM
Word 2007: can't edit recipient list johnthebaptist Mailmerge 9 December 17th 07 06:34 PM
How do I print a recipient list from a mail merge list in Word? Randog Mailmerge 1 June 20th 06 06:52 PM


All times are GMT +1. The time now is 03:54 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"