Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2002 Mail Merge Error via Excel 2002, XP Op System
This only happens on one file. I received a download of data in an
excel file (same version I run, same op system I run) and saved the original file and then saved a copy of the file under a new name and sorted the data, split the data between 3 worksheets based on specific criteria, applied general formating (col width, row height, color, etc.). I use the merge wizard in Word 2002, which I have done hundreds of times. But this document is giving me intermittent problems. I follow the below method. Document Type: Letter Start Document: Use the current doc Select recipients: Browse I select the copy of the original file Select Table: I choose Sheet1$ from the following options: additional$, approved$, dvo7lkup$, rejected$) When the mail merge recipient window opens it is not populated with Sheet1$ information it has sheet additional1$ I X out and go back to: Select a different List I select the same file (copy of the original file) Now the Select Table has the following options: Sheet1$, Sheet2$, Sheet3$, and so on. I select Sheet1$ (I have selected them all in hopes of troubleshooting) and the mail merge recipient window is blank. If I close out and start over it is correct. But if I decide that I need to tweak the data more and cancel the merge and come back later the same thing happens again. I tested the original doc and I do not get the errors. I checked to see if there was code b/c there shouldn't be on a simple text doc. and there isn't any code. the VBA is the same on the original as it is on the copy. The original was sent from the same version of windows and op system. I cannot figure this out. I know just use the original but what if this occurs again. I would appreciate any insight anyone can give me. Thank you so much! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
printing difficultiies using mail merge in word | Mailmerge | |||
Mail Merge (Word 2002 SP3)- | Mailmerge | |||
Word 2002 cannot find its Excel data source for mail merge | Mailmerge | |||
How do I set sup a mail merge from Excel to Word if the system ca. | Mailmerge |