With LabelMark6 from Brady, high performance
label printing has never been easier. And now, you can import data from Excel and other
sources in just a few clicks. Here’s how: When you open the application, click on Create
on the home screen, and select New Label. For this tutorial we’ll be working with THT-155
label material. So in the new window that opens up, type that into the search bar. The
list below will automatically filter as you type, so select THT-155 when it pops up. Now
we’ll be in Graphics Mode for this label as well, so double check to make sure it’s highlighted
here. Then, hit the Create button in the lower right of the application. In the navigation
at the top of the window, click on Insert, and in the drop-down, select ExternalData.You
can import from a variety of sources, such as Delimited Text, Microsoft Access, or any
other OLE DB data source. We’re going to be working with an Excel spreadsheet here, so
click on the radial for Microsoft Excel Spreadsheet, and then hit Select Source to navigate to
your data source. I’ve got a demo spreadsheet created for this, right here. I’ll grab that
and hit Open. Then we’ll go ahead and press Next select the sheet and the columns we want
to use, and then press Next again. By default, all of the columns will appear on the label
as text. You can see that here. Just remember that what you see on this screen is the general
setup for the labels that will be created. So Part Numbers and Reference are simply our
column names. We’ll use this view to set the layout. Use the Select tool and the Object
Properties on the left pane of the window to visually style your label design. I’ll
go ahead and change the font type and make Part Numbers bold. For the Reference column
in this demo, I actually want that to show up as a barcode instead of text. So I’m going
to remove the text object for the Reference column by selecting it and clicking here.
And then we’ll re-add that column as a barcode by selecting this radial and dragging Reference
from the data fields window directly onto the label. One of the cool things with LabelMark6
is that we can easily change the code type. Look how quickly we can make this a QR code.
Now that we’re all laid out, you can hit Next, and the data placement window will open up.
You can use it to really customize your print based on your needs. So if you prefer adding
this data to every other label or having the sequence print horizontally or vertically,
you can arrange that on this screen. I’m going to print every label in left to right, so
I’ll simply hit Next. With the setup now complete, you’ll see the option to save the scheme if
you like. I’ll save it here as Demo and hit Finish. And there you go! We’ve imported all
the data from the spreadsheet, and the labels are laid out based on the design we just created.
The last step now is to select Errors and Information at the bottom of the application.
That’s going to let us know if there will be any data drop-off. Just hit Check Label
for Errors. And once that clears, you’re ready to print!


5 Comments

Justin Chadburn · October 11, 2016 at 9:33 am

Hi
Can you then save this as a template, so next time you just change the spreadsheet and print?

Mohan Raj · January 22, 2018 at 8:04 am

Is it Compatible with windows 10 ?

Jan Zalobinski · May 7, 2018 at 12:42 pm

External data can't be imported to template files. Visual element positioning can't be saved to a data import scheme. Am I missing something here?

Cadastre SIG · February 26, 2019 at 7:50 am

How to import quantity ?

Robbie Murchison · October 30, 2019 at 7:56 pm

Hey, is there a way to stop duplicate labels from being printed? I can't seem to manage it with the 'Refresh Values' options.

Leave a Reply

Your email address will not be published. Required fields are marked *