HELP!!! Using Mail Merge Wizard / Access v2002

[hwhitney]

What I Do:
I use Mail Merge wizard to generate labels from the MS
Access queries I generate from MS Acess Tables.

I export from MS Access to a Mail Merge Word file. I open
MS Word and run the Mail Merge Tool and create my labels
from the Mail Merge File (Select document, select
recipients, choose layout, copy layout to all labels,
complete mail merge).

Problem:

Everything appears to work fine but when I look at the
final product - the label files layout - I see that the
same labels -same meaning a group of fourteen- are
repeated over and over. Sheet to sheet.

When I pick the recipients I see no duplicates.

I need to solve this problem asap

Why


..

 

[Doug Robbins - Word MVP]

For starters. why don't you do the whole thing in Access? It has a built in
wizard to create a report that prints to labels.

With your Word setup however was it a label type mailmerge main document
that you started with. Did you actually execute the merge (either to a
printer or a new document) Try it to a new document and see if it exhibits
the problem you mention.

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