34 | 7.3 Merging Information, Sequencing Labels
DuraLabel.com | 800.788.5572
LABEL DESIGN
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 11 Bottom half of the Insert
Merge Field button selected, with
column header names displayed.
FIGURE 10 Select the Excel sheet
number where your data is located
from the Select Table dialog box.
FIGURE 12 Word document ready to
receive data from Excel Column A.
To Next Page
Loading...
