Like I said in my reply to this thread...keep this in a separate table in Access...just for this merge...use the ORIGINAL table for your counts, then your counts won't be false (you can just update the merge table from the original table whenever you add students to that, with an append query) Linda Linda's Computer Stop http://personal-computer-tutor.com ABC Free Ezine ~ Free Ebooks and Tutorials *all outgoing mail scanned by Norton AV. If you got a bug that looks like it came from me, it did NOT! -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Cherie Sent: Monday, May 31, 2004 7:25 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: E-mail merge using Access and Word Forgot to mention in that long reply..that my ultimate goal is EACH student have only ONE record until I figure out how to put two (or more ) email addresses in the ONE email field and have it work using outhouse..I have made duplicate records for students that have more than one email address..this avoids having to send a merge twice (once for email1, then for email2)..but it creates a false count for how many students are signed up. thanks Cherie ---Thanks, Cherie ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************