I have a Dell Poweredge 600SC running Windows 2000,
Access, and Word XP. I have an Access Data Base from
which I am trying to merge names and address's onto
mailing labels. I'm using the Avery 5160 Template. I get
one record in the first position and nothing there after.
How do I get it to advance to a new record for each label
position?
For starters, it is not necessary to use Word at all to
do this. Access has
a Report Wizard that will do it.
The step that you have missed in Word is to replicate the
mergefield set up
to each label on the sheet. For a detailed description of
the process, see
the following page on fellow MVP Graham Mayor's website:
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature
Please post any further questions or followup to the
newsgroups for the
benefit of others who may be interested. Unsolicited
questions forwarded
directly to me will only be answered on a paid consulting
basis.
Hope this helps
NEW QUESTION!!!!!!!!
How do I make it add pages until the entire database is
exhausted???????
Doug Robbins - Word MVP - 28 May 2004 04:25 GMT
You have to execute the merge to either a new document or a printer.
That is detailed on Graham's website to which I referred you.

Signature
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> I have a Dell Poweredge 600SC running Windows 2000,
> Access, and Word XP. I have an Access Data Base from
[quoted text clipped - 15 lines]
>
> http://www.gmayor.com/mail_merge_labels_with_word_xp.htm