Hey Lisa....since I know you use Access a lot, I'm curious why you don't just leave the data in Access and use Access's Label Wizard? That will let you sort just like any other report. Maybe Access 2000 doesn't have the label wizard? I can't remember, but I know it's in 2002 and 2003 (New Object button>Report>Label Wizard) The problem in Word is the name, address, etc. are all in one table cell so you can only sort by what's the first thing in the cell, which could be a first name, could be "Mr.", could be anything, but I'm assuming you want to sort them by last name? 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 Green Sent: Saturday, November 27, 2004 6:50 PM To: MSO Subject: [mso] word 2000 mail labels Oops... FFS... Fa finger syndrome... apologies I have been trying to create labels for printing from an Access database... No problem really except I'm frustrated that I can't get them sorted!! If I choose the TABLE I can opt to sort in the query options but have to set up fields. If I sort them in a query and choose the query then they don't come out sorted!! Any suggestions about why they don't please?? Lisa ************************************************************* 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 *************************************************************