Mail Merge Wizard - Labels

[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

 

[x]

did you try to view the result of your query?

 

[hwhitney]

Yes. I view the results and that is where I see the
duplication. BUt when I select recipients, I see no
duplication. Curiously enough, if I choose Edit after
completing the mail merge and look at the results, all the
data is there and there are no duplicates. The problem
seems to be in the Complete Mail Merge Step and overridden
by opening the file and saving it as a straight word doc.

 

[x]

correct me if im wrong. as i understand it
if you use the query as your mail merge record source,
probably, there's an error on the query..
looking at the table itself doesnt have a duplicates, but
when we create a query, based on the conditions, sometimes
duplications happens. have you tried to use the table
itself as your record source?

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>