Dymo LabelManager Series, User Manual

Page: 16 / 28

Making Labels
12
NOTE
If the contents of the label are too long to fit vertically on a fixed width label, the excess
content is truncated. This action cannot be undone once you click Yes.
2
Click Yes .
The text of your label is now displayed in a single vertical column.
Printing Labels Using Data from Another Program
LabelMANAGER includes two commands that allow you to print labels from other programs:
Smart Paste and Merge Print from Database. The Smart Paste command allows you to print
multiple labels from a list created in a word processing, spreadsheet, or other similar program.
Merge Print from Database allows you to print labels from a text or Comma Separated Value (CSV)
file exported from a database program.
Spreadsheet Text
When copying and pasting rows of text from a spreadsheet program using Smart Paste, each row is
treated as a separate label and each cell in the row is treated as a separate line on the label.
For example, the rows in the following spreadsheet:
will print two three-line labels: one for DYMO and one for Esselte.
Text File
Many programs can create a text file, such as a text editing program, a database application, and so
on. When you export text from a database, you usually create a delimited file with each entry
separated by comma or tab characters, and a carriage return/line feed at the end of each entry.
Both the Smart Paste and the Merge Print from Database commands recognize the delimiter
characters and will insert a line break on the label. When a comma is used as a delimiter, make sure
the text that contains any commas that you want to print on the label is enclosed in quotation marks.
The carriage return/line feed will start a new label.
NOTE
The separator character may be different for countries other than the US. When using Smart
Paste, the list separator character is based on the Windows list separator (or regional setting)
being used.
For example, the following lines of text (delimited using commas):
DYMO Corp., 44 Commerce Road, “Stamford, CT 06902”
Esselte, 48 South Service Road,“Melville, NY 11471”
DYMO Corp.
44 Commerce Road
Stamford, CT 06902 Esselte
48 South Service Road
Melville, NY 11471