I found a fix for this by creating a Word template to handle the merge process and always opening the template, rather than a new doc from the template. For some reason it seems this gets over the OLE/DDE hiccup. Might be worth a try? Anne -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Glenda Wells Sent: 09 October 2003 15:04 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: yet another Mail Merge problem I have the same problem with Word documents that we changed the data source on. Saving the file doesn't seem to take. I still must select my data source every time I want to do a particular merge. My original data source was an Excel spreadsheet. We changed to Access and have one table with a letter code field that corresponds with a particular Word document. We want to link to that table and that particular letter code. Some documents work and some don't. I don't know yet what they have in common. I can link to the data source. choose the criteria to equal the desired letter code and save the document. Next time, gotta do it all over again. /g -----Original Message----- From: Richard Plecenik [mailto:rplecen@xxxxxxxxxxxxx]=20 Yup....that's the way I thought it was supposed to work, but I=20 apparently lose the link to the query when I close the file. When I=20 re-open the file the calculated fields from the query are zeroed and I=20 have to relink the query. I've tried this on a number of the files and I get the same results. ************************************************************* 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 ************************************************************* --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 ************************************************************* 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 *************************************************************