document assembly using Word 2003 Mailmerge

[JudyL]

I am working on a project for a client who uses Word 2003. they are merging a mailmerge main document with an Excel 2003 file. Each data file record has a field in it specifying the path and another specifying the document and the rest of the record providing data to merge to the document specified in the path and document fields. I am using an Includetext statement:
{INCLUDETEXT "{MERGEFIELD} WORDPATH}\\{MERGEFIELD WORDFILENAME}"}
The above statement then merges to the appropriate file which contains merge fields that merge the rest of the data in the data record.

This all works file except that I can't get it to pull from the correct paper tray. To add to the problem, all documents must be printed double-sided. I have tried putting different kinds of section breaks in (continuous and next page) but I either get extra blank pages or printing on the wrong side of the page.

Any ideas?

 

[TonyJollans]

How are you trying to (a) print and (b) select the paper tray?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[JudyL]

My paper trays are set in Page Setup. I am not sure what you mean by "How are you trying to print". The merge results in a merged document and then I send it to the printer. As you know, when you do a mailmere, each time you merge to a new record, a section break is inserted. That seems to be throwing off my page settings. I tried to have my controlling main document be set up as a directory instead of a letter and then put next page section breaks in the documents that would be merged in but that really messed up the results in terms of from which tray the paper was pulled.

 

[macropod]

Cross-posted (and answered) at:

http://answers.microsoft.com/en-us/...ith-word/044485b0-365b-4be0-a2a1-51dc5a5cc671

Judy, for cross-posting etiquette, please read:

http://www.excelguru.ca/node/7

Cheers
Paul Edstein
[MS MVP - Word]