Thanks for the Advice! It was a great help! I have only one question left.. Is there a way to automatically insert a value in the SENT column when sending/merging/printing .. ? So that we don't need to worry about manually inserting these values .. Thanks in advance! Franz-Robert -----Oorspronkelijk bericht----- Van: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] Namens Linda F. Johnson Verzonden: vrijdag 15 oktober 2004 16:06 Aan: mso@xxxxxxxxxxxxx Onderwerp: [mso] Re: word - How to see which adresses have been used in mailmerge Urgentie: Hoog Which version of Word are you using? If it's Word 97 or 2000, at the bottom of the mail merge window you see a button beside the Merge button that says "Query Options". Click on that and you can click on the Filter Options tab in there and choose the field you created in Access and make it " not egual to" whatever value you put in the records for the ones that have already been sent. If you are using Word 2002 or 2003, to get to this box, go to Step 3 of the Mail Merge. Then click on "Edit Recipient List" in your Task Pane. You will see dropdown arrows at the top of each column. Click on any arrow and choose "Advanced") 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 Franz-Robert van Vugt Sent: Thursday, October 14, 2004 9:11 PM To: mso@xxxxxxxxxxxxx Subject: [mso] word - How to see which adresses have been used in mailmerge Hello to all! Does anyone now how you can store the adresses used in a mailmerge? I have a access database, where I get my addresses from. I made a mail merge in word. So now I am able to select multiple addresses and make word merge them. I would like to store the addresses, so I can see whom I sent a (snail!) mail already. The way I think is best, is to creat an extra column in the access table, saying which ID has already been mailed.. and somehow not display the already mailed ones in word. The question is, how can I do a query or something like that in word, so that this information will be stored in the database? I hope this explanation of my problem is clear enough.. Thanks in advance! Kind regards, Franz-Robert van Vugt ************************************************************* 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 ************************************************************* ************************************************************* 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 *************************************************************