Automatically merge to new document then print duplex

[FionaLFI]

I need to produce a series of A3, two-sided sheets each week using data from a Microsoft Access database - there is a different set of data on each side of the sheet. I have written a macro which merges one set of data to a new document and then inserts the other set as a second page. It then dimensions this new document to A3. I want it to send it to print duplex, but I can't find how to do this. Can I insert PCL commands into the VB code? I can't put them as a field command in the document itself, because a new document is created each time.

Very grateful for any help.

 

[HughLerwill]

Have never tried using the Duplex Property when using the Microsoft VB Printer Dialog VbPrnDlg.dll'ref.

http://support.microsoft.com/default.aspx?scid=kb;en-us;322710

but it is supported.

 

[HughLerwill]

The Duplex Property is also supported in the vb Printer Object; have you tried using that.

 

[macropod]

Hi Fiona,

If you're creating the document from a template, you can add the PRINT field to that. Furthermore, even if you're creating the document from scratch, you can add the PRINT field to document using code. That way, it will always print duplex. For example:

Dim Rng As Range
With ActiveDocument
  Set Rng = .Sections(1).Headers(wdHeaderFooterPrimary).Range.Characters.First
  Rng.Collapse wdCollapseStart
  .Fields.Add Range:=Rng, Type:=wdFieldEmpty, Text:="PRINT 27""&l1S""", PreserveFormatting:=False
End With

Cheers
Paul Edstein
[MS MVP - Word]

 

[dilettante]

It looks like you really want forum705

This one is for the full application development systems VB 5 & VB6, not for Access macro issues.