[[email protected]]

I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB in
size and took a while, at least 2 minutes to just open the document,
when I tried to scroll to the last page, it looked like it would take
forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!

[macropod[_2_]]

Any 400+MB document with 10,000+ pages is going to take some time to open and process. Unless there's a compelling reason to have so
many records in the one file, I'd suggest splitting the merge into a number of smaller jobs (eg 1,000 records each).

--
Cheers
macropod
[Microsoft MVP - Word]


wrote in message ...
I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB in
size and took a while, at least 2 minutes to just open the document,
when I tried to scroll to the last page, it looked like it would take
forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!

[Graham Mayor]

I think you did well to complete the merge. The fact that it is slow to load
or to navigate through a document of over 400 mb (when the quoted text limit
for Word is 32mb!) is not at all surprising.

When I first read your post, I created a small macro to insert a new page
section break at the bottom of a single page Word 2003 document, and paste a
page of text after the break, to loop 10,000 times. This is much the same
process as creating a merge document without the overhead of reading from an
Excel file to get the data for each of those 10,000 pages! After 15 minutes,
the process appeared to have hung so I broke out of the macro and found that
somewhat less than 6000 pages had been created - a document of 26 mb. I then
copied and pasted that document to the end to produce a document of over
11,000 pages (50 mb), which loads quickly but then takes an age to
repaginate, as you might expect, and the page counter loses the will to live
at 9,999.

A merge document will come with rather more baggage than a plain text
document, but 8 times as much? How big is the merge document before the
merge? Try pasting all of it except the last paragraph mark into a new
document and see how large that document is by comparison. If the merge
document has additional elements such as graphics, frames, tables etc, then
all bets are off.

The fact is that you are taking Word to places it was never intended to go
and are exploring the limits of performance of your PC. I would suggest that
you merge more manageable chunks of data into separate documents.


--

Graham Mayor - Word MVP

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



wrote:
I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB in
size and took a while, at least 2 minutes to just open the document,
when I tried to scroll to the last page, it looked like it would take
forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!

[macropod[_2_]]

Hi Graham,

Even without exceeding the oft-cited 32MB text limit, a single graphic on each page could soon push the file size for a 10,000 page
document out over 400MB. And even Word 2007 chokes on file sizes anything over 512MB!

--
Cheers
macropod
[Microsoft MVP - Word]


"Graham Mayor" wrote in message ...
I think you did well to complete the merge. The fact that it is slow to load or to navigate through a document of over 400 mb (when
the quoted text limit for Word is 32mb!) is not at all surprising.

When I first read your post, I created a small macro to insert a new page section break at the bottom of a single page Word 2003
document, and paste a page of text after the break, to loop 10,000 times. This is much the same process as creating a merge
document without the overhead of reading from an Excel file to get the data for each of those 10,000 pages! After 15 minutes, the
process appeared to have hung so I broke out of the macro and found that somewhat less than 6000 pages had been created - a
document of 26 mb. I then copied and pasted that document to the end to produce a document of over 11,000 pages (50 mb), which
loads quickly but then takes an age to repaginate, as you might expect, and the page counter loses the will to live at 9,999.

A merge document will come with rather more baggage than a plain text document, but 8 times as much? How big is the merge document
before the merge? Try pasting all of it except the last paragraph mark into a new document and see how large that document is by
comparison. If the merge document has additional elements such as graphics, frames, tables etc, then all bets are off.

The fact is that you are taking Word to places it was never intended to go and are exploring the limits of performance of your PC.
I would suggest that you merge more manageable chunks of data into separate documents.


--

Graham Mayor - Word MVP

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



wrote:
I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB in
size and took a while, at least 2 minutes to just open the document,
when I tried to scroll to the last page, it looked like it would take
forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!

[Graham Mayor]

I am not sure where that 32 mb limit comes from. It is easy enough to create
'text only' documents larger than that (such as the 50mb 11,000 page jobby I
mentioned earlier).

--

Graham Mayor - Word MVP

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



macropod wrote:
Hi Graham,

Even without exceeding the oft-cited 32MB text limit, a single
graphic on each page could soon push the file size for a 10,000 page
document out over 400MB. And even Word 2007 chokes on file sizes
anything over 512MB!

"Graham Mayor" wrote in message
...
I think you did well to complete the merge. The fact that it is slow
to load or to navigate through a document of over 400 mb (when the
quoted text limit for Word is 32mb!) is not at all surprising. When I
first read your post, I created a small macro to insert a new
page section break at the bottom of a single page Word 2003
document, and paste a page of text after the break, to loop 10,000
times. This is much the same process as creating a merge document
without the overhead of reading from an Excel file to get the data
for each of those 10,000 pages! After 15 minutes, the process
appeared to have hung so I broke out of the macro and found that
somewhat less than 6000 pages had been created - a document of 26
mb. I then copied and pasted that document to the end to produce a
document of over 11,000 pages (50 mb), which loads quickly but then
takes an age to repaginate, as you might expect, and the page
counter loses the will to live at 9,999. A merge document will come
with rather more baggage than a plain
text document, but 8 times as much? How big is the merge document
before the merge? Try pasting all of it except the last paragraph
mark into a new document and see how large that document is by
comparison. If the merge document has additional elements such as
graphics, frames, tables etc, then all bets are off. The fact is that
you are taking Word to places it was never intended
to go and are exploring the limits of performance of your PC. I
would suggest that you merge more manageable chunks of data into
separate documents. --

Graham Mayor - Word MVP

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



wrote:
I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB
in size and took a while, at least 2 minutes to just open the
document, when I tried to scroll to the last page, it looked like
it would take forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!

[macropod[_2_]]

Hi Graham,

The 32MB limit comes directly from MS (http://support.microsoft.com/kb/211489) and supposedly applies to Word 2000-2007.
Unfortunately, it's been poorly expressed in the Help files. For example, in Word 2000's help file, it's expressed as "Maximum file
size -32 megabytes (MB)", without the benefit of the "for the total document text only" note in the KB article. In any event, I
doubt it's a true reflection of Word's capacity, since I too have created files with well over 33,554,432 characters (ie 32MB of
text) in Word 2000.

--
Cheers
macropod
[Microsoft MVP - Word]


"Graham Mayor" wrote in message ...
I am not sure where that 32 mb limit comes from. It is easy enough to create 'text only' documents larger than that (such as the
50mb 11,000 page jobby I mentioned earlier).

--

Graham Mayor - Word MVP

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



macropod wrote:
Hi Graham,

Even without exceeding the oft-cited 32MB text limit, a single
graphic on each page could soon push the file size for a 10,000 page
document out over 400MB. And even Word 2007 chokes on file sizes
anything over 512MB!

"Graham Mayor" wrote in message
...
I think you did well to complete the merge. The fact that it is slow
to load or to navigate through a document of over 400 mb (when the
quoted text limit for Word is 32mb!) is not at all surprising. When I first read your post, I created a small macro to insert a
new
page section break at the bottom of a single page Word 2003
document, and paste a page of text after the break, to loop 10,000
times. This is much the same process as creating a merge document
without the overhead of reading from an Excel file to get the data
for each of those 10,000 pages! After 15 minutes, the process
appeared to have hung so I broke out of the macro and found that
somewhat less than 6000 pages had been created - a document of 26
mb. I then copied and pasted that document to the end to produce a
document of over 11,000 pages (50 mb), which loads quickly but then
takes an age to repaginate, as you might expect, and the page
counter loses the will to live at 9,999. A merge document will come with rather more baggage than a plain
text document, but 8 times as much? How big is the merge document
before the merge? Try pasting all of it except the last paragraph
mark into a new document and see how large that document is by
comparison. If the merge document has additional elements such as
graphics, frames, tables etc, then all bets are off. The fact is that you are taking Word to places it was never intended
to go and are exploring the limits of performance of your PC. I
would suggest that you merge more manageable chunks of data into
separate documents. --

Graham Mayor - Word MVP

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



wrote:
I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB
in size and took a while, at least 2 minutes to just open the
document, when I tried to scroll to the last page, it looked like
it would take forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!

I think that complexity of the document is an important criteria too. Loads
of direct formatting instead of using styles will severely reduce the
potential size that you can produce.

Terry Farrell

"macropod" wrote in message
...
Hi Graham,

The 32MB limit comes directly from MS
(http://support.microsoft.com/kb/211489) and supposedly applies to Word
2000-2007. Unfortunately, it's been poorly expressed in the Help files.
For example, in Word 2000's help file, it's expressed as "Maximum file
size -32 megabytes (MB)", without the benefit of the "for the total
document text only" note in the KB article. In any event, I doubt it's a
true reflection of Word's capacity, since I too have created files with
well over 33,554,432 characters (ie 32MB of text) in Word 2000.

--
Cheers
macropod
[Microsoft MVP - Word]


"Graham Mayor" wrote in message
...
I am not sure where that 32 mb limit comes from. It is easy enough to
create 'text only' documents larger than that (such as the 50mb 11,000
page jobby I mentioned earlier).

--

Graham Mayor - Word MVP

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



macropod wrote:
Hi Graham,

Even without exceeding the oft-cited 32MB text limit, a single
graphic on each page could soon push the file size for a 10,000 page
document out over 400MB. And even Word 2007 chokes on file sizes
anything over 512MB!

"Graham Mayor" wrote in message
...
I think you did well to complete the merge. The fact that it is slow
to load or to navigate through a document of over 400 mb (when the
quoted text limit for Word is 32mb!) is not at all surprising. When I
first read your post, I created a small macro to insert a new
page section break at the bottom of a single page Word 2003
document, and paste a page of text after the break, to loop 10,000
times. This is much the same process as creating a merge document
without the overhead of reading from an Excel file to get the data
for each of those 10,000 pages! After 15 minutes, the process
appeared to have hung so I broke out of the macro and found that
somewhat less than 6000 pages had been created - a document of 26
mb. I then copied and pasted that document to the end to produce a
document of over 11,000 pages (50 mb), which loads quickly but then
takes an age to repaginate, as you might expect, and the page
counter loses the will to live at 9,999. A merge document will
come with rather more baggage than a plain
text document, but 8 times as much? How big is the merge document
before the merge? Try pasting all of it except the last paragraph
mark into a new document and see how large that document is by
comparison. If the merge document has additional elements such as
graphics, frames, tables etc, then all bets are off. The fact is that
you are taking Word to places it was never intended
to go and are exploring the limits of performance of your PC. I
would suggest that you merge more manageable chunks of data into
separate documents. --

Graham Mayor - Word MVP

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



wrote:
I used Excel as the datasource and it has 10,000+ records. My word
template has 1 pages and 10+ merge fields. It took over an hour to
merge to a new document with 10,000+ pages. The document was 400+MB
in size and took a while, at least 2 minutes to just open the
document, when I tried to scroll to the last page, it looked like
it would take forever.

Are there any ways to speed up the merge process or any workarounds
for my situation?

Thanks!