Dymo LabelWriter® 450 Twin Turbo Dual Roll Label and Postage Printer for PC - Page 86

Using the Excel Add-In (Windows), Print, Print Label, Address Fixer, Select label layout

Page 86 highlights

Printing Labels from Other Programs 9. Click Print. A label prints using the selected settings. Using the Excel Add-In (Windows) DYMO Label software includes a software add-in so you can quickly print labels from a Microsoft Excel document. The add-in works with Microsoft Excel 2002 or later. The Excel Add-in treats each column in a row as a line of data on the label and each row as a new label. You can use the add-in to preview your labels and change the label properties before printing, or you can use Quick Print to print labels using the last selected settings. To use the Excel Add-in 1. Select the cells that contain the text you want to print on your label. 2. Click Print Label in the toolbar. The DYMO Excel Add-In dialog box appears. 3. Make any necessary changes to the text to be printed. You can make edits to the data in the text box; however, these edits will not be saved in the original data. 4. If you selected more than one row of text, click Next to review the data for each label. 5. (Optional) Click Address Fixer to verify and correct any addresses you selected. 6. Do the following to select the print options: a. Choose a label layout to use from the Select label layout list. b. If necessary, choose a printer from the Select printer list. c. (Twin Turbo Only) Choose the label roll to print to from the Select label roll list. You can also click Options to select a different printer and to visually choose the label type or layout. 7. Click Print. A label prints for each row of text you selected. Click Quick Print to print labels using the most recent settings. Using the Excel Add-In (Mac) DYMO Label software includes a software add-in so you can quickly print labels from a Microsoft Excel document. The add-in works with Microsoft Excel 2004 or later. The Excel Add-in treats each column in a row as a line of data on the label and each row as a new label. To use the Excel Add-in 1. Select the cells that contain the text you want to print on your label. 2. Do one of the following: l (Excel 2004) Click in the toolbar. l (Excel 2008) Choose DYMO LabelWriter from the The DYMO Excel Add-In dialog box appears. menu. 78

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122

Printing Labels from Other Programs
9.
Click
Print
.
A label prints using the selected settings.
Using the Excel Add-In (Windows)
DYMO Label software includes a software add-in so you can quickly print labels from a
Microsoft Excel document. The add-in works with Microsoft Excel 2002 or later.
The Excel Add-in treats each column in a row as a line of data on the label and each row as
a new label.
You can use the add-in to preview your labels and change the label properties before
printing, or you can use Quick Print to print labels using the last selected settings.
To use the Excel Add-in
1.
Select the cells that contain the text you want to print on your label.
2.
Click
Print Label
in the toolbar.
The DYMO Excel Add-In dialog box appears.
3.
Make any necessary changes to the text to be printed.
You can make edits to the data in the text box; however, these edits will not be
saved in the original data.
4.
If you selected more than one row of text, click
Next
to review the data for each label.
5.
(Optional) Click
Address Fixer
to verify and correct any addresses you selected.
6.
Do the following to select the print options:
a.
Choose a label layout to use from the
Select label layout
list.
b.
If necessary, choose a printer from the
Select printer
list.
c.
(Twin Turbo Only) Choose the label roll to print to from the
Select label roll
list.
You can also click
Options
to select a different printer and to visually choose the
label type or layout.
7.
Click
Print
.
A label prints for each row of text you selected.
Click
Quick Print
to print labels using the most recent settings.
Using the Excel Add-In (Mac)
DYMO Label software includes a software add-in so you can quickly print labels from a
Microsoft Excel document. The add-in works with Microsoft Excel 2004 or later.
The Excel Add-in treats each column in a row as a line of data on the label and each row as
a new label.
To use the Excel Add-in
1.
Select the cells that contain the text you want to print on your label.
2.
Do one of the following:
l
(Excel 2004) Click
in the toolbar.
l
(Excel 2008) Choose
DYMO LabelWriter
from the
menu.
The DYMO Excel Add-In dialog box appears.
78