Salesforce

How to Print Directly From Excel to Brady Printers

« Go Back

Content

 
Article Number000010060
TitleHow to Print Directly From Excel to Brady Printers
Body
Note: This workaround is not routinely updated or validated. Troubleshooting print issues caused by 3rd party software is outside of Brady Technical Support's scope of support. Brady offers free labeling software for the BMP71: How to Download & Install the free Basic Design Suite for Brady Workstation

Purpose
This is simply a short description of how to accomplish basic printing to the BMP71 from Excel, without using any Brady label editing software packages. The BMP71 is used as an example in this article, however these settings could be applied to any Brady printer with an installed driver. 

Printer Preferences in Driver
Install the Brady BMP71 printer drivers and set the Paper size in the driver to match the part in the printer.

Note: If you are using continuous media, set the page driver size to a die-cut label that matches the size of the individual labels you are trying to create. 

1.    Start Menu > Devices & Printers (Search 'Devices and Printers' in Windows 10)
2.    Select the BMP71 and right-click
3.    Choose Printing Preferences
User-added image
 
4.    Click on Advanced…
 
User-added image
 
5.    Click Paper Size > Properties

User-added image

6.    Select the part in use

User-added image


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 BMP71 materials change.
URL NameBMP71-How-to-Print-Directly-From-Excel-to-the-BMP71-printer

Powered by