F
flybynight
When attempting to print labels created through mail merge in word 2003 the
printer will only print one page of labels correctly. Subsequent pages of
labels are fed through the printer with blank pages or gobblygook. The print
preview looks fine. My print driver is correct, and up to date. Canon will
not support this issue. Does anyone have any suggestions? Thanks I am
following the steps as suggested by palm:
On your PC, launch Palm Desktop. Click on Contacts (Address Book).
Highlight the records for which you want to create address labels.
Right-click on the highlighted list of records. Select the menu item Send
To, then MS Excel.
Make a note of which columns in the Excel document contain the fields you
want to include on the labels.
E.g. Column A contains Name. Columns K, L, M and N contain address.
Save the Excel spreadsheet to a location you'll remember, and close Excel.
Launch Word.
From the View menu, select Toolbars, then Mail Merge. The Mail Merge toolbar
will appear near the top of your screen.
In the Mail Merge toolbar, click on the Mail Document Setup icon (the first
icon on the left, on most setups).
A window will appear, asking for a document type. Select Labels, then click
OK.
In the next window, select the label product and size. Then click OK. You
will be returned to the new Word document, and you may see shadow outlines of
the labels on the page.
In the Mail Merge toolbar near the top of the screen, click on the Open Data
Source icon (the second icon from the left, on most setups).
Locate the Excel spreadsheet you saved earlier. Uncheck the box for "First
row of data contains column headers," and click Open. The new Word document
will fill in the label spaces with «Next Record».
In the Mail Merge toolbar, click on the Insert Mail Merge Fields icon (the
sixth icon from the left, on most setups).
The Insert Merge Field window opens.
These fields correspond to the columns in the Excel spreadsheet you created
above. They use numbers instead of letters. So, Columns K, L, M and N in the
spreadsheet equal F11, F12, F13 and F14 in this window. The first field
(Column A in the spreadsheet, which are the names of your contacts) will be
labeled Contacts. Click on a field (such as F11), and click Insert. Repeat
for all the fields you want to use in the labels. When finished, click on
Close.
The first label in the Word document will now be populated with all the
fields you just inserted. Add carriage returns, spaces, and commas to format
the address label as you wish.
Example: In our Excel spreadsheet, the fields correspond as follows
Contacts - Name
F11 - Street Address
F12 - City
F13 - State
F14 - Postal code
Therefore, the Word document would look like this:
«Contacts»«F11»«F12»«F13»«F14»
and after formatting it would look like this:
«Contacts»
«F11»
«F12», «F13» «F14»
At this point, you can also modify font, alignment and other settings. Just
highlight the fields to be changed, and make the adjustment.
On the Mail Merge toolbar, click on the Propagate Labels icon (the tenth
icon from the left, on most setups). All labels on the page will be filled as
above.
On the Mail Merge toolbar, click the Merge To New document icon (the
seventeenth icon from the left, on most setups). When asked in the Merge To
New Document window, select All, then OK.
A new Word document will open with your mailing labels.
Using the instructions above as a guideline, you can select different
options depending on what you want to do (such as create form letters, e-mail
letters or envelopes). For more information about using a "Mail Merge", see
the Microsoft support: Mail Merge FAQs (article 290408).
printer will only print one page of labels correctly. Subsequent pages of
labels are fed through the printer with blank pages or gobblygook. The print
preview looks fine. My print driver is correct, and up to date. Canon will
not support this issue. Does anyone have any suggestions? Thanks I am
following the steps as suggested by palm:
On your PC, launch Palm Desktop. Click on Contacts (Address Book).
Highlight the records for which you want to create address labels.
Right-click on the highlighted list of records. Select the menu item Send
To, then MS Excel.
Make a note of which columns in the Excel document contain the fields you
want to include on the labels.
E.g. Column A contains Name. Columns K, L, M and N contain address.
Save the Excel spreadsheet to a location you'll remember, and close Excel.
Launch Word.
From the View menu, select Toolbars, then Mail Merge. The Mail Merge toolbar
will appear near the top of your screen.
In the Mail Merge toolbar, click on the Mail Document Setup icon (the first
icon on the left, on most setups).
A window will appear, asking for a document type. Select Labels, then click
OK.
In the next window, select the label product and size. Then click OK. You
will be returned to the new Word document, and you may see shadow outlines of
the labels on the page.
In the Mail Merge toolbar near the top of the screen, click on the Open Data
Source icon (the second icon from the left, on most setups).
Locate the Excel spreadsheet you saved earlier. Uncheck the box for "First
row of data contains column headers," and click Open. The new Word document
will fill in the label spaces with «Next Record».
In the Mail Merge toolbar, click on the Insert Mail Merge Fields icon (the
sixth icon from the left, on most setups).
The Insert Merge Field window opens.
These fields correspond to the columns in the Excel spreadsheet you created
above. They use numbers instead of letters. So, Columns K, L, M and N in the
spreadsheet equal F11, F12, F13 and F14 in this window. The first field
(Column A in the spreadsheet, which are the names of your contacts) will be
labeled Contacts. Click on a field (such as F11), and click Insert. Repeat
for all the fields you want to use in the labels. When finished, click on
Close.
The first label in the Word document will now be populated with all the
fields you just inserted. Add carriage returns, spaces, and commas to format
the address label as you wish.
Example: In our Excel spreadsheet, the fields correspond as follows
Contacts - Name
F11 - Street Address
F12 - City
F13 - State
F14 - Postal code
Therefore, the Word document would look like this:
«Contacts»«F11»«F12»«F13»«F14»
and after formatting it would look like this:
«Contacts»
«F11»
«F12», «F13» «F14»
At this point, you can also modify font, alignment and other settings. Just
highlight the fields to be changed, and make the adjustment.
On the Mail Merge toolbar, click on the Propagate Labels icon (the tenth
icon from the left, on most setups). All labels on the page will be filled as
above.
On the Mail Merge toolbar, click the Merge To New document icon (the
seventeenth icon from the left, on most setups). When asked in the Merge To
New Document window, select All, then OK.
A new Word document will open with your mailing labels.
Using the instructions above as a guideline, you can select different
options depending on what you want to do (such as create form letters, e-mail
letters or envelopes). For more information about using a "Mail Merge", see
the Microsoft support: Mail Merge FAQs (article 290408).