| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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 | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recent Docs list in Word 2007--limit to #s? | Microsoft Word Help | |||
| Editing Mail Merge Recipient List in Word 2007 | Microsoft Word Help | |||
| Recipient List in Word 2007 | Mailmerge | |||
| Word 2007: can't edit recipient list | Mailmerge | |||
| How do I print a recipient list from a mail merge list in Word? | Mailmerge | |||
Hybrid Mode
