User`s guide

32
DuraLabel.com 800.788.5572
LABEL DESIGN
D. When all your data has been entered in the Excel spreadsheet, name and save
your document in a location where you can easily find it. Consider placing it in a
folder with other project documents. Close your Excel document after naming and
saving it. You’ll come back to it shortly.
E. Now open the Word template you want to
import your Excel data into. In Figure 7 the
static text “Part Number:” and “Description:” are
already typed in. Now place your cursor where
you want to insert your data.
F. Select the Mailings tab from the Word menu
bar, then click on Select Recipients and Use
Existing List (Fig. 8). A Select Data Source
window appears (Fig.9).
G. Locate and select the Excel spreadsheet you just
saved using the Select Data Source window (Fig. 9).
A Select Table dialog box appears (Fig. 10).
H. Select the Excel Spreadsheet page where your data
is located, e.g., Sheet 1, on the Select Table dialog
box. The Select Table dialog box closes when you
make your selection.
I. Now click on the bottom half of the Insert Merge
Field button on your Word toolbar (Fig. 11). The
names of your column headers will be displayed.
J. Select Column A header. A Column A space-holder
(<<Part_Numbers>>) appears next to the Column A
header (Fig. 12).
FIGURE 7 Word document ready to receive
data from an Excel spreadsheet
FIGURE 8 Choose
“Select Recipients”
and “Use Existing List”
from the Mailings tab.
FIGURE 9 Navigate
the Select Data Source
window to access your
Excel le.
FIGURE 10 Select the Excel sheet
number where your data is located
from the Select Table dialog box.
FIGURE 11 Bottom half of the Insert
Merge Field button selected, with
column header names displayed.
FIGURE 12 Word document
ready to receive data from Excel
Column A.