Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-24-2017, 03:50 AM
Piotrwilczak Piotrwilczak is offline Print Macro Windows 7 64bit Print Macro Office 2016
Novice
Print Macro
 
Join Date: May 2017
Posts: 1
Piotrwilczak is on a distinguished road
Default Print Macro

Hello



We are using the macro below to print a copy on Plain and Letterhead at the same time . The application which we use is on remote server and our print server is on local network ( I think we use something called Remote Desktop Easy Print which kind of redirects the print job from the server on which the application reside to print server in our office). For the macro to work we have to edit it and change the redirected values every day.
Is there a way to edit this macro to specify the range of numbers (lets say from 1 to 65,000) no matter to which number printing is redirected macro would still work?



Sub Macro1()
'
' Macro1 Macro
'
'
ActivePrinter = _
"TCL012 - Team A - Headed on abctclfls001 (redirected 613)"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentWithMarkup, Copies:=1, Pages:="", PageType:= _
wdPrintAllPages, Collate:=True, Background:=True, PrintToFile:=False, _
PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
ActivePrinter = "TCL012-Team A on abctclfls001 (redirected 613)"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentWithMarkup, Copies:=1, Pages:="", PageType:= _
wdPrintAllPages, Collate:=True, Background:=True, PrintToFile:=False, _
PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
End Sub

I would be grateful if you could assist .

Thank You


Piotr
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I print a different quantity of each page? A macro maybe? unittwentyfive Word 2 04-05-2014 07:47 PM
Print Macro Print Macro w/ Page Range? stickyit Outlook 1 10-06-2011 09:51 AM
Print Macro Creating macro to convert/print to pdf shabbaranks Word 3 05-18-2011 08:59 AM
Print Macro Macro for Print sivakl2001 Word VBA 6 03-24-2011 11:25 PM
Print Macro in MS Word steve207 Word VBA 0 09-10-2010 02:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft