If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge Wizard - Labels
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 |
#2
|
|||
|
|||
Mail Merge Wizard - Labels
did you try to view the result of your query?
-----Original Message----- 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 . |
#3
|
|||
|
|||
Mail Merge Wizard - Labels
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? -----Original Message----- 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 . . |
#4
|
|||
|
|||
Mail Merge Wizard - Labels
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 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? -----Original Message----- 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 . . . |
Thread Tools | |
Display Modes | |
|
|