Papersource

[domino1352]

I have created a connection to MSWORD to do a mail merge, I want it to print first page from tray one and second page from Papersource 2, which is a valid thing to do in a mailmerge, i.e covering letter and an invoice. but it seems that a mail merger producess only one document so only the first document gets the correct paper the balance gets printed all on Paper source 2...
the code I am using is as follows

Set WordObj = CreateObject("Word.Application")
Set wordDoc=WordObj .Documents.Add(filepath)
worddoc.MailMerge.OpenDataSource( MergeFilepath)
worddoc.MailMerge.Destination=0 worddoc.MailMerge.Execute(False)
Wordobj.PrintOut

I have set the template (document found at 'filepath') to have firstpage papersource1 and balance papersource2
has anyone had similar problems?

 

[fumei]

You could split the merged document into individual documents, and then print. Each would get first page print Tray 1, second Source 2.

Or, you could write a print macro that alternates paper source by Sections. Odd Sections numbers to Tray 1, even to Source 2. This assumes of course that things are neatly sectioned out.

Gerry

 

[SkipVought]

Or...

set up separate Printer Profiles for each paper type.

Then change the ActivePrinter & PrintOut Pages: properties for each part of the document

Skip,
[sub]
[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion! [/sub]

 

[domino1352]

Thanks for your Reponses
Fumie can give me an example of a macro that will print different pages to different pages..
thanks