A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

MailMerge: Label - Problems (Next Record)



 
 
Thread Tools Display Modes
  #1  
Old September 5th 07, 08:32 PM posted to microsoft.public.word.mailmerge.fields
FensterBos
external usenet poster
 
Posts: 1
Default MailMerge: Label - Problems (Next Record)

I am trying to "merge" a list of addresses on an Excel sheet (.XLS) to a Word
document (.DOC) using the Mail Merge - Labels tool. Basically, I am trying
to use Mail Merge for what it is suppose to be used for.
When I follow the Mail Merge Wizard, I enter the correct document type
(labels), and then select the specific label option/type/size, then use "an
existing list" for my recipients. At that point, I select the respective
Workbook and Sheet; the wizard shows me a faux list of the addresses I want
to merge into my Word document, everything looks in order. However, when I
click 'OK' and continue to arrange and preview my labels, all I see is a
"Next Record" message inside the labels, and eventually nothing when I
complete the merge.
Everything seems to be in order, so I do not know what I am doing wrong.
What step am I missing? Is it the Excel file?
Ads
  #2  
Old September 5th 07, 08:58 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default MailMerge: Label - Problems (Next Record)

I suspect that the basic problem you have is that you need to say what
fields and text you want to print on your labels. For once, Word does not
try to guess!


the wizard shows me a faux list of the addresses I want
to merge into my Word document,


Does it? At this point, I see two options:-

Select a different list...

Edit recipient list...

This is in "Step 3 of 6" in te Word 2003 Mail Merge Wizard.

If you then click "Next: Arrange your labels", then what you have to do is
a. insert the fields and "trim" that you need
b. click "Update all labels"
c. click "Next: Preview your labels"
d. after you have done anything you need to do in Step 5 of 6...
e. click Next: Complete the merge
f. either
- Print or
- Edit Standard Labels, then print the output document

In step (a) (Step 5 or 6) you need to insert the fields that you want to
print on your labels.

If you have a Tablet PC, step (b) may fail. There is some evidence that the
same may happen with some versions of Windows Vista. In that case, have a
look at

http://tips.pjmsn.me.uk/t0005.htm

--
Peter Jamieson
http://tips.pjmsn.me.uk

"FensterBos" wrote in message
...
I am trying to "merge" a list of addresses on an Excel sheet (.XLS) to a
Word
document (.DOC) using the Mail Merge - Labels tool. Basically, I am
trying
to use Mail Merge for what it is suppose to be used for.
When I follow the Mail Merge Wizard, I enter the correct document type
(labels), and then select the specific label option/type/size, then use
"an
existing list" for my recipients. At that point, I select the respective
Workbook and Sheet; the wizard shows me a faux list of the addresses I
want
to merge into my Word document, everything looks in order. However, when
I
click 'OK' and continue to arrange and preview my labels, all I see is a
"Next Record" message inside the labels, and eventually nothing when I
complete the merge.
Everything seems to be in order, so I do not know what I am doing wrong.
What step am I missing? Is it the Excel file?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Next record problems... klklklbbb Mailmerge 2 August 9th 07 06:32 AM
label using Next Record If Karren Mailmerge 6 May 16th 07 07:46 AM
Mailmerge: First Record in stead of Next Record Guus Mailmerge 6 February 6th 07 04:00 PM
Labels with more than one excel record per label susanb Microsoft Word Help 1 April 20th 06 02:02 PM
Mailmerge Next record John T Mailmerge 1 March 2nd 06 01:10 PM


All times are GMT +1. The time now is 08:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.