Mail Merge Recipients only shwoing 1st 10,000 Names

E

egral

When I pop up the mail merge recipients box I only see the 1st 10,000 names,
if I sort them z-a order, I then only to see 10,000 of them in reverse order.
There must be a setting to make this box show more than 10,000?
 
P

Peter Jamieson

There must be a setting to make this box show more than 10,000?

There might be, but in my experience, 10,000 is the limit.

That could be a "hint" from Microsoft that Word MailMerge is probably not a
very good way to do merges larger than that. But you would have to ask
them...
 
E

egral

Microsoft will not help, they tell me my Office Pro 2007 sorfware is OEM
Dell, Dell says call Microft and back and forth.... Just purchased computer
Jun-6-2008.
 
P

Peter Jamieson

Well, I don't think MS are likely to fix this limitation any time soon.

But perhaps it's really a question of how the limitation impacts you.

Frankly, the recipients dialog box is not a very good place to
select/deselect/filter or modify large volumes of data. If you need to do
that, you are likely to be much better off doing it outside Word, probably
in the same place the data comes from. For example, if you are using a large
Excel sheet as a data source, you'll probably be better off seelcting your
data in there and creating the data source you need, then doing the merge.
If you are using Word to report on large numbers of records, you might be
better off using e.g. Access reporting, or perhaps even something like SQL
Server Reporting Services (I'm thinking of things inside the "Microsoft
world" at the moment but of course there are other possibilities). At a
certain point it isn't even a question of whether or not Word is technically
capable of doing the thing you want to to - it's whether or not it also
provides tools to help you manage the process, especially when things go
wrong - e.g. when your printout stops after you processed 13500 records - or
was it 13501?

Personally I would prefer it if Word did this stuff better but if it doesn't
do what you need, you really have to consider looking elsewhere.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top