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
|
|||
|
|||
2003 Small Business - Mail Merge from Excel Sheet Duplication Oddi
I have a workbook in excel named "Calculate" that has a worksheet named
"Label-List" Label list looks like this: (Column A) =calculate!$J$2 =calculate!$J$2 =calculate!$J$2 =calculate!$J$2 =calculate!$J$3 =calculate!$J$3 =calculate!$J$3 =calculate!$J$3 .... =calculate!$J$81 =calculate!$J$81 =calculate!$J$81 =calculate!$J$81 That gives me 320 entires I use Word 2003 to Mail Merge via the sidepane wizard. I am using Avery 5267 Return Address page setup. My setup looks as such: | Label-List | Next RecordLabel-List | Next RecordLabel-List | etc... I then save that setup as MergedLabels.doc so that I can have others use it as well (all files are on a Publicly Shared Folder on the File Server). When anybody opens the document, it will pop up as mention that a SQL command will need to run, just like it's supposed to do, and everything SEEMS okay. Here is the oddity: When we "Merge to New Document" by either the wizard or the Mail Merge Toolbar on Word 2003 and 2002, we get this as the result: | 1122 | 1122 | 1122 | 1122 | | 1122 | 1123 | 1123 | 1123 | | 1123 | 1124 | 1124 | 1124 | etc. As you can see, it has taken the first value and put it in FIVE times. The Data source only has 4 entries. And here's the Twist: If I have the Mail merge Toolbar up when I first open MergedLabels.doc, I can do this: If I hit the "View Merged Data" button (the one that looks like abc) on the toolbar, it will preview the merged data, and I will have the 5 entries. I then click the "View Merged Data" button again to return to the "design" view. I then IMMEDIATELY RECLICK the "View Merged Data" button to re-preview the merged labels, and everything is PERFECT. Meaning, I get this: | 1122 | 1122 | 1122 | 1122 | | 1123 | 1123 | 1123 | 1123 | | 1124 | 1124 | 1124 | 1124 | I did nothing to change anything! All I did was Preview the Merged labels, un-previewed, then re-previewed!!! Arooo? - Los |
#2
|
|||
|
|||
Previewing has the effect of updating the fields, so updating the fields in
the merge document should effect the same result, however there are easier ways to produce numbered labels - see http://www.gmayor.com/Numbered_labels.htm - if that is what you are trying to do, and removing the {next} fields from labels 2, 3 & 4 would obviate the need to duplicate records to produce four labels with the same data. You may also find http://www.gmayor.com/mail_merge_lab...th_word_xp.htm useful? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Los wrote: I have a workbook in excel named "Calculate" that has a worksheet named "Label-List" Label list looks like this: (Column A) =calculate!$J$2 =calculate!$J$2 =calculate!$J$2 =calculate!$J$2 =calculate!$J$3 =calculate!$J$3 =calculate!$J$3 =calculate!$J$3 ... =calculate!$J$81 =calculate!$J$81 =calculate!$J$81 =calculate!$J$81 That gives me 320 entires I use Word 2003 to Mail Merge via the sidepane wizard. I am using Avery 5267 Return Address page setup. My setup looks as such: Label-List | Next RecordLabel-List | Next RecordLabel-List | etc... I then save that setup as MergedLabels.doc so that I can have others use it as well (all files are on a Publicly Shared Folder on the File Server). When anybody opens the document, it will pop up as mention that a SQL command will need to run, just like it's supposed to do, and everything SEEMS okay. Here is the oddity: When we "Merge to New Document" by either the wizard or the Mail Merge Toolbar on Word 2003 and 2002, we get this as the result: 1122 | 1122 | 1122 | 1122 | 1122 | 1123 | 1123 | 1123 | 1123 | 1124 | 1124 | 1124 | etc. As you can see, it has taken the first value and put it in FIVE times. The Data source only has 4 entries. And here's the Twist: If I have the Mail merge Toolbar up when I first open MergedLabels.doc, I can do this: If I hit the "View Merged Data" button (the one that looks like abc) on the toolbar, it will preview the merged data, and I will have the 5 entries. I then click the "View Merged Data" button again to return to the "design" view. I then IMMEDIATELY RECLICK the "View Merged Data" button to re-preview the merged labels, and everything is PERFECT. Meaning, I get this: 1122 | 1122 | 1122 | 1122 | 1123 | 1123 | 1123 | 1123 | 1124 | 1124 | 1124 | 1124 | I did nothing to change anything! All I did was Preview the Merged labels, un-previewed, then re-previewed!!! Arooo? - Los |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mail merge, envelope addressing from excel database | jej | Mailmerge | 1 | May 2nd, 2005 06:12 AM |
Merge data from Excel into different docs in one Word file | sue_w1231 | Mailmerge | 1 | November 16th, 2004 12:55 AM |
Does Office Small Business Edition 2003 Excel support Lotus 1-2-3. | mypoppop | Setting up and Configuration | 0 | November 4th, 2004 04:49 PM |
Can I send a mail merge using contacts in Excel via Outlook? | Kristen | Contacts | 1 | October 8th, 2004 11:15 PM |
Mail Merge to Fax - Word 2003 | Paul | General Discussion | 1 | June 9th, 2004 02:19 PM |