Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
Word 2003 Mail Merge Performance
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 Thesaurus performance | Microsoft Word Help | |||
Microsoft Word 2003 Performance Issue | New Users | |||
Word 2003 - Tables performance | Tables | |||
Word 2003 performance | Microsoft Word Help | |||
Exchange 2003 - Outlook 2003 - Word 2003 mail merge | Mailmerge |