label using Next Record If Karren 5/9/2007 3:00:02 PM I am trying to create a label that catalogs student information. I want to go to the next record if the ID number changes. First line I have and ID number, Last name and First name. The second line I have inserted a table where I have four fields. My excel file have multiple lines with the same ID number (same person) and I want a list of the information that pertains to that number. I'm guessing that I would use the Next Record If statement but I don't know what to put in the Compare to field.

Re: label using Next Record If "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/9/2007 4:43:40 PM Before you go much further on this one, I suggest you a. consider creating this applicaiton in Access (if you have it) rather than Word, because Word is not really designed to do this kind of mailmerge b. see http://homepage.swissonline.ch/cindymeister/mergfaq1.htm and http://support.microsoft.com/default.aspx?scid=kb;en-us;211303 Peter Jamieson "Karren" <Karren[ at ]discussions.microsoft.com> wrote in message news:8AA48D01-5189-4A50-961C-78356C1A556B[ at ]microsoft.com... [Quoted Text] >I am trying to create a label that catalogs student information. I want to > go to the next record if the ID number changes. First line I have and ID > number, Last name and First name. The second line I have inserted a table > where I have four fields. My excel file have multiple lines with the same > ID > number (same person) and I want a list of the information that pertains to > that number. I'm guessing that I would use the Next Record If statement > but > I don't know what to put in the Compare to field.