[Jecca]

I have a letter as Word doc that uses a SQL command to pull mail merge data
from another Word doc. We recently upgraded to Office 2007 and ever since
then if I make a change to the body of the letter and then save it, the next
time I open it the command warning box doesn't open and my "edit recipient
list" box is grayed out. I then have to revert to the previously saved
version to get it to work. I make sure that it is saved as .doc not .docx
but that doesn't help. Any suggestions?

[Peter Jamieson]

I have a letter as Word doc that uses a SQL command to pull mail
merge data
from another Word doc.

I suggest you
a. get to the point where you can work with the mail merge main
document, whether or not it has a data source attached.
b. click Mailings tab-Start Mail Merge group-Start Mail
Merge-Normal Word Document. That should disconnect the mail merge data
source. You will lose any sorts/filters/selections but you should not
lose any of the field codes in your document.
c. save and close the document
d. re-open the document, then attach the data source
e. save and close and try re-opening again.

Peter Jamieson

http://tips.pjmsn.me.uk

On 02/02/2010 00:50, Jecca wrote:
I have a letter as Word doc that uses a SQL command to pull mail merge data
from another Word doc. We recently upgraded to Office 2007 and ever since
then if I make a change to the body of the letter and then save it, the next
time I open it the command warning box doesn't open and my "edit recipient
list" box is grayed out. I then have to revert to the previously saved
version to get it to work. I make sure that it is saved as .doc not .docx
but that doesn't help. Any suggestions?

[Jecca]

Thank you so much! It works now. One more thing - is there a way to make
the "preview results" selected by default?

[Peter Jamieson]

A very quick experiment suggests that if you select /preview results/
then save and close the mail merge main document, preview results may
well be on when you re-open. (Actually, it is difficult to tell what
makes such settings "sticky") If you need something more reliable than
that, you'll need a VBA AutoOpen macro in the document ofr the attached
template.

Peter Jamieson

http://tips.pjmsn.me.uk

On 02/02/2010 16:33, Jecca wrote:
Thank you so much! It works now. One more thing - is there a way to make
the "preview results" selected by default?