InsertFile (include text) or AddFromFile (master)

[Susie W]

We need to print and send some standard information with each proposal that
we send out. So our people open the proposal, print it, then open the
information document, print that out, then possibly a third document, and
print that out.

I'd like to set up a template so they open a blank document, just click a
button that says "Include file" that runs a macro that lets them select each
file, then links it to the document.

If I use InsertFile, I lose the formatting. I can't change all the source
documents to have a section break at the beginning.

I thought of using Master Documents (ONLY FOR PRINTING!), figured I would
use AddFromFile method with READONLY = TRUE to protect the included
documents. But setting READONLY = true doesn't seem to protect the documents
from being modified, so I'm afraid it won't keep them from getting corrupted.
I don't really care what happens to the master document as long as the source
documents stay safe.

Any idea? Or should I just give up?

 

[Bear]

Susie:

Never give up.

Two ideas occur to me. First, you seem only to need to clump the documents
together at print time, i.e. the only reason you're trying to combine them
seems to be to print them in one pass. Why don't you make your userform build
a list of docs to print, then print that list when they say "OK?"

Second, you could Master Document away with impunity if your macro copied
the additional documents into an assembly folder for the Master Document.
Then you'd only stand to corrupt the copies.

Bear

 

[Susie W]

You're a very wise bear. I like the first idea. I can put the names of the
file in a table so it will look nice, and then just read the table and open
and print each one.
I'll try it and let you know how it goes. Thanks.

 

[Bear]

Susie:

Glad I could help. Do let us know how it goes!

Bear