A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Limit of 10,000 records on recipient list in Word 2007



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 11:32 AM posted to microsoft.public.word.mailmerge.fields
Brendan K
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  
Old April 27th, 2010, 02:23 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
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  
Old April 28th, 2010, 11:55 AM posted to microsoft.public.word.mailmerge.fields
Brendan K[_2_]
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

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.