DYMO label printable database?

**kramsay** · 03-03-2009, 01:00 PM

How can I create a database in Excel to keep track of videos that will print an individual label (Dymo LabelWriter 400) for each tape in a series? An example of a tape number we use is: D1 A-G 09. The A-G represents tapes 1-7. Currently I enter the information manually into the Dymo software to print individual labels for each tape, ie D1 A 09, D1 B 09, D1 C 09,... I'm currently in the process of creating a new library database and would really like to be able to automatically create labels for each tape.

**shg** · 03-03-2009, 01:08 PM

Set your printer to the Dymo and set the printer properties for the correct label size.

Do Page Setup and set the margins to 0, and center on page horizontally and vertically.

Set a page break after every row, or resize the column height and width so it comes out that way.

Print it.

**kramsay** · 03-03-2009, 01:21 PM

Thanks. Is there any way to auto create a label? Like maybe format a cell within the spreadsheet that contains all information from the database that I want on the label? I would like to figure out a way to create the number of labels I need for each set of tapes. The number of tapes ranges for each set.