Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2004

Tip: Looking for answers? Try searching our database.

Mail Merge Wizard - Labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hwhitney@cancergenetics.com - 20 May 2004 16:03 GMT
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 - 20 May 2004 18:41 GMT
did you try to view the result of your query?

>-----Original Message-----
>What I Do:
[quoted text clipped - 21 lines]
>
>.
hwhitney@cancergenetics.com - 20 May 2004 19:04 GMT
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.

>-----Original Message-----
>did you try to view the result of your query?
[quoted text clipped - 27 lines]
>>
>.
x - 20 May 2004 21:00 GMT
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?

>-----Original Message-----
>Yes.  I view the results and that is where I see the
[quoted text clipped - 38 lines]
>>
>.
Graham Mayor - 21 May 2004 08:41 GMT
See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

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

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

> What I Do:
> I use Mail Merge wizard to generate labels from the MS
[quoted text clipped - 18 lines]
>
> Why
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.