At the end of each day, clinics will export the Drug Log to Excel and print it so that the vet can sign it. The pages get hole punched and stored in a binder. For some clinics, this file is very large and ends up printing super tiny if you try to fit it to one page and just may not be the ideal layout for that clinic.
Need the Macro to automatically change the layout preferences of your Drug Log with a few less clicks?
Create Your Own Macro
Watch this great YouTube video: https://www.youtube.com/watch?v=uyj_OljPlcU
Alternative to Macro
Each time you print, right-click on the column details that you do not need to be displayed on the printed log.
From the menu, choose to Hide the column.
Hiding a columnOn the print setup screen, change the page orientation to print Landscape and Fit All Columns to One Page.
Orienting your report