Announcement

Collapse
No announcement yet.

For those good at mail merging in VBA

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    For those good at mail merging in VBA

    I have soem access vba I use to open a document, merge a query to it and then print the results. The problem is I need it to print double sided, and we have a printer to do that, but it isn't every users default printer. My code sends the prints to whatever the default printer is with no options and settings in place.

    Does anyone have a good knowledge of this and guide me into telling it to use Printer X (I think I might have that part) but more importantly, to set the double sided printing within the vba code?

    #2
    In fact right now I can't even get the blasted document to print to a chosen printer from word. If I set it to this doubled sided printer, it reverts back to my default each time I open word!!! How do I set that?

    Comment

    Working...
    X