Macros -- Using a Macro to Find the Printer Name

For some macros you need to know the exact name of your printer. If you make a mistake, the macro won't work. Fortunately, you can use this macro to find your printer's name.

1. Click Tools
2. Select Macros
3. In the Macro name box, enter a name for the macro
4. Click Create
5. When the VB Editor opens, paste the following text:

Debug.Print ActivePrinter

6. Close the VB Editor
7. Run the macro
8. Open the VB Editor Alt + F11
9. Press Ctrl + G
10. The Immediate window will display the printer name