Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jecca Jecca is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jecca Jecca is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default 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?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help file will not work-work 2007 dehard Microsoft Word Help 0 January 6th 09 02:51 PM
Word 2007 Help will not work Kirk Zehnder Microsoft Word Help 4 May 23rd 08 09:57 PM
Does EndNote 9.0 work with Word 2007? If so, how? stabbi Microsoft Word Help 2 March 20th 08 06:29 AM
word 2007 failing to work Mark Mace Microsoft Word Help 0 October 23rd 07 11:42 AM
TABLET PC Pen Does Not work In Word 2007 ED WRIGHT Tables 0 July 24th 07 11:16 PM


All times are GMT +1. The time now is 07:09 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"