Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
flybynight flybynight is offline
external usenet poster
 
Posts: 1
Default printing difficultiies using mail merge in word

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).




























  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default printing difficultiies using mail merge in word

Try executing the merge to a New Document and see if that is OK. If so,
print it.

Also See the article "Mail Merge to Labels with Word XP" on fellow MVP
Graham Mayor's website at:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"flybynight" wrote in message
news
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).






























Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Why can't I get Multiple instances of word? Laverne Microsoft Word Help 14 November 17th 06 02:35 PM
Editing Mail Merge Recipients Stan W. Mailmerge 8 May 4th 06 05:03 AM


All times are GMT +1. The time now is 09:11 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"