Printing Sheets to Multiple Destinations

  • Thread starter Thread starter Michelle72
  • Start date Start date
M

Michelle72

Is there anyway to "program" an Excel workbook to print each sheet to a
different printer?
Here is my situation:
I use a workbook to send daily prices to my customers. The first sheet
is my data entry and each sheet following is customly set up to suit
the appropriate customer and linked to the data entry sheet. I then
click on each sheet and fax to the appropriate customer using
WinFax.(each sheet goes to a different fax number)
I'm looking for a way to automate my faxing/printing process. Is there
a macro or anything that can be added in each sheet of my workbook so
it will fax to the appropriate customer?
Any ideas would be greatly appreciated.

Thanks,
Michelle
 
I don't know how Winfax is working but with this you can change to a other printer(your fax)

Sub printer1()
Application.ActivePrinter = "hp officejet k series on Ne00:"
ActiveSheet.PrintOut
End Sub

This macro you can assign to a button

To know the names of your pinters
Change to it in the ctrl P dialog (Cancel after choose the printer ) and run
this so you now the name that you must put in the macros

Sub nameprinter()
MsgBox Application.ActivePrinter
End Sub
 
Back
Top