Label and Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin - 24 May 2004 21:03 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 24 May 2004 23:23 GMT

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
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 - 3 lines]
> How do I get it to advance to a new record for each label
> position?

Reply to this Message