|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 2nd, 2010, 12:50 AM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
SQL doesn't work with Word 2007?
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? 
|
|
#2
February 2nd, 2010, 02:47 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
SQL doesn't work with Word 2007?
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?
|
|
#3
February 2nd, 2010, 04:33 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
SQL doesn't work with Word 2007?
Thank you so much! It works now. One more thing - is there a way to make
the "preview results" selected by default?
|
|
#4
February 2nd, 2010, 06:39 PM
posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
SQL doesn't work with Word 2007?
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
