Salesforce

How to print to the BMP51 from Excel

« Go Back

Content

 
Article Number000011249
TitleHow to print to the BMP51 from Excel
Body
Purpose

This is simply a short description of how to accomplish basic printing to the BMP51 from Excel, without using any Brady label editing software packages.

Printer Preferences in Driver

Install the Brady BMP51 printer drivers and set the Paper size in the driver to match the part in the printer.
1.    Start Menu > Devices & Printers (Search 'Devices and Printers' in Windows 10)
2.    Select the BMP51 and right-click (click Manage for Windows 10)
3.    Choose Printing Preferences

4.    Click on Advanced…

 

 
5.    Click Paper Size > Properties




6.    Select the part in use




Excel Margins and Printer Preferences

Set up the page sizes in Excel. Many of the dialogs will look the same as in the previous step.
1.    Click on the Page Layout tab
2.    Select Margins > Custom Margins
3.    Change all margins to “0”

User-added image

4.    Click Options… 
5.    Choose Landscape
6.    Click Advanced…
7.    Select Paper Size and click Properties
8.    Choose the same part size 

Editing in Excel

Now you can start creating your labels in Excel. Your blank spreadsheet should look something like this:

User-added image

Enter some data and select what you want to print. Set the Print Area (Page Layout> Print Area).

User-added image

Now you can print in the usual manner. Remember that the page size will need to change as your BMP51 materials change.
URL NameHow-to-print-to-the-BMP51-from-Excel

Powered by