Printing 1,000 20-page documents -- 1 at a time

[WBJ]

I am merging a 20-page Word 2003 document with a 1,000 record Excel 2003
spreadsheet. I need 1,000 individual PDFs. At 45 seconds per document, this
will take 12 1/2 hours (assuming no breaks and no errors).

Is there a way to batch print all of these PDFs at once WHILE MAINTAINING
EACH DOCUMENT AS A SEPARATE FILE?

 

[Doug Robbins - Word MVP]

An issue is going to be supplying the filename for each .pdf file.

The add-in that I have created that you can download from the following page
of fellow MVP Graham Mayor's website, will save each document created by the
execution of the mailmerge to a new document, as a separate file with the
filename taken from a field in the datasource and also has the ability to
save those files as .pdf files.

http://www.gmayor.com/individual_merge_letters.htm

--
Hope this helps.


Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[WBJ]

When I downloaded and then opened the file, "MMtoDocsRev28" (which the link
"Word add-in template" in "www.gmayor. . . ) took me to, a blank Word file
opened -- nothing else.

 

[Doug Robbins - Word MVP]

You don't open the file, you "Extract the MMtoDocsRevnn.DOT template (where
nn is the latest revision number) to the Word startup folder - its location
defined in Word at Tools > Options > File Locations > Startup."

That is, you save it in the Word Startup folder. Then you restart Word,
then you execute your merge to a new document and you will be asked if you
want to create separate documents for each record and if you answer yes, a
dialog box will appear with a list of the merge fields in your data source
from which you select the field that contains the data that is to be used as
the filename. You also indicate whether that field includes the file path
or if not, you browse to and select the folder into which the documents will
be saved. There is also a box that you check if you want to create .pdf's
of each document (requires appropriate .pdf software)

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[WBJ]

I have two STARTUP files -- one in OFFICE11 and the other in OFFICE12. When I
try to save to either of them, I am told I need administrator-level
permission. How do I get that? As this is my only computer. I am the only
user.

 

[Doug Robbins - Word MVP]

Did you check the location of the WORD Startup folder (under
Tools>Options>File Locations) in Word.

It is usually at:

C:\Documents and Settings\[User Name]\Application
Data\Microsoft\Word\Startup

OFFICE does not come into it!

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

Wouldn't it be simpler if you read the instructions on the web page that
accompanied the download?
http://www.gmayor.com/individual_merge_letters.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>