Hey Pete...I'm no Access whiz, but I bet you are having the same problem the director of Eclectic Academy has....she has all of us instructors in an Access database and when she sends us our class schedules via a mail merge using Outlook, we get a separate email for each class we teach, instead of all in one. Since James LaBorde (a member of this group and an EA instructor) has been helping her with this and we still get multiple emails, I'm guessing this is not easy to do...but hopefully someone in here can shed some light on this so James can help her do the same thing I think you are trying to do. Eagerly waiting for the solution to this one...unless it's not the same...is it James? And Pete....PLEASE don't include the entire digest when you reply....that message was a whopper LOL Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Pete Home Sent: Tuesday, April 15, 2003 12:54 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Invoicing Mailmerge I have a query on an access 2002 database that I want to use as a = mailmerge. The query is for invoicing purposes, so it shows customer details and purchase details. OK, it's pretty easy to generate a invoice in Word, = but where a customer has several purchases, I end up with several invoices rather than one invoice with all purchases on it. Is this possible to do? Regards Pete ************************************************************* 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 *************************************************************