Incomplete Mail Merge WMgirl 12/12/2008 7:26:00 PM I have an Excel database to be merged into Word 2007 for labels. The first time I did the labels, there were over 1000 and all merged just fine. For this mailing, I have reduced the database to 997 but only the first 48 of the names will merge. What is going on? I need help quickly. My client expects this project yesterday, of course.

Re: Incomplete Mail Merge "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/12/2008 9:28:35 PM 1. Are there any empty rows in the sheet (e.g. a hidden row after row 48/49) ? 2. Are you still "merging" rather than e.g. printing to a 48-label sheet? You have to "complete the merge" - if you don't you'll just see a single sheet. (Doesn't sound like that to me) 3. When you go through the data source selection process in Word, are you seeing any names in the list of "tables" other than the sheet name? If you have also defined any Excel Range Names that reference part of the sheet, and you used a name similar to the Sheet name, make sure you select the Sheet and not the Range name. (Doubt if it's that eiher but it's all I can think of right now) -- Peter Jamieson http://tips.pjmsn.me.uk "WMgirl" <WMgirl[ at ]discussions.microsoft.com> wrote in message news:7E93D9C0-FDB5-4975-BE4B-5B1697A7366A[ at ]microsoft.com... [Quoted Text] >I have an Excel database to be merged into Word 2007 for labels. The first > time I did the labels, there were over 1000 and all merged just fine. For > this mailing, I have reduced the database to 997 but only the first 48 of > the > names will merge. What is going on? I need help quickly. My client expects > this project yesterday, of course.

Re: Incomplete Mail Merge WMgirl 12/13/2008 7:44:05 PM 1. No empty rows anywhere. 2. I know that depending on where I view the results, I'll either see the first page of all it; even in "edit" in Word all I could see was 48 rows as if the rest didn't exist. 3. I referenced the entire sheet not just part of it. I got an error message at one point that said the file was corrupt when Word tried to use it for the merge. That's when I copied and pasted the sheet from Excel to Word and used it for the merge. I saved it as a Word file and was able to get the blasted thing finished and off to my client. Whew! Thanks for your help, James, I'll keep your suggestions handy for the next merge I do. Until this time, I didn't know an empty row would stop the merge. A simple thing. "Peter Jamieson" wrote: [Quoted Text] > 1. Are there any empty rows in the sheet (e.g. a hidden row after row 48/49) > ? > 2. Are you still "merging" rather than e.g. printing to a 48-label sheet? > You have to "complete the merge" - if you don't you'll just see a single > sheet. (Doesn't sound like that to me) > 3. When you go through the data source selection process in Word, are you > seeing any names in the list of "tables" other than the sheet name? If you > have also defined any Excel Range Names that reference part of the sheet, > and you used a name similar to the Sheet name, make sure you select the > Sheet and not the Range name. (Doubt if it's that eiher but it's all I can > think of right now) > > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "WMgirl" <WMgirl[ at ]discussions.microsoft.com> wrote in message > news:7E93D9C0-FDB5-4975-BE4B-5B1697A7366A[ at ]microsoft.com... > >I have an Excel database to be merged into Word 2007 for labels. The first > > time I did the labels, there were over 1000 and all merged just fine. For > > this mailing, I have reduced the database to 997 but only the first 48 of > > the > > names will merge. What is going on? I need help quickly. My client expects > > this project yesterday, of course. > >