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
|
|||
|
|||
HELP!!! Using Mail Merge Wizard / Access v2002
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
|
|||
|
|||
HELP!!! Using Mail Merge Wizard / Access v2002
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 " wrote in 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 | |
|
|