Two suggestions, just in case you have not tried them
1...
a. open your mail merge main document and go through the steps
necessary to connect (again).
b. use "Mailings-Start Mail Merge to change the document type to
"Normal Word document
c. save and close the document
d. re-open the document. You should not see any messages about a data
source
e. re-connect to the data source and set the mail merge document type
as required
f. save and close the document
g. re-open the document. You will at least see the "SQL" message box
(unless you have already made the change to the Windows registry that
fixes that). But with any luck, the connection will then proceed without
further effort.
2...
a. If you do not need the features of the .docx format, keep to .doc.
b. then if necessary, do (1).
Peter Jamieson
http://tips.pjmsn.me.uk
On 07/01/2010 23:24, Tina wrote:
I know how to merge docs and it has worked perfectly until the "upgrade to
2007" Now I have to redo the steps to finding the data base every time I want
to merge a doc...the steps are not saving with the file...I've read a ton on
this problem but I have not read a solution...does anyone have a solution?
word 2007 with access 2007...on my desktop no server involved.