Using Office 2010, I do alot of mail merge letters using Word and Excel. Normally I use the same main Word document which I merge with various Excel files. In one case the main document is a dotx file, in another case it's a docx file. At the end of the mail merge I save each letter as an individual Word file.
When I later go to open a saved letter, I get a prompt stating Opening this document will run the following SQL command, then gives the data source and asking if you want to continue. If you answer yes, the file opens. With some letters, it then says it cannot find the data source, then gives a Select Data Source dialog box - eventually when you click cancel the letter opens. This is because the letter thinks it is linked to a previously used data source, not the one used to create the letter.
My problem is that I want to be able to email the letters to various managers for signing. I used to send pdf files but some of the managers like to use an electronic signature so I need to send the Word file. I think these messages will confuse them - especially the second example where they get 3 messages before the file will open.
Any help will be appreciated.
