Duplex Macro

C

Cole

Hello computer gods and goddesses,

I've got a Word 2003 document that I'm trying to create a VBA macro
for simply to tell it which printer to go to, and to print Duplex 3
(vertical binder.)

I'm still in the early stages of learning the ropes. But I've been
unable to get a macro to fire off when the document gets opened by
another application, (i.e. sdOffice,) OR when a Mail Merge occurs...

My sorry attempt at coding this follows. This is in a Template
document (.dot extension.) I was hoping that when the document was
opened, it would fire off this event and do my procedure. But I'm
obviously clueless. I get no message box...

Sub Document_Open()
ActiveDocument.PageSetup.Orientation = wdOrientPortrait
ActivePrinter = "P9638" 'This is temporary to send this doc
to
'the printer near IT

MsgBox ("active printer is " & ActivePrinter)

End Sub

I've also tried: Sub Document_New() thinking it's creating a new doc
from the Template that this code is within.

Be it known, I've already sacrificed a chicken. I hope that helps at
least a bit :) Does anyone have a suggestion of a really good Word
VBA for Dummies - type book? (I'd like to find substantially more
comprehensive than the Dummies series, but still clear for beginners!)

Thanks for the help !!!
Cole
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top