View Merged data not working "Barbara Wiseman" <this.is.not[ at ]real.email.address> 12/13/2008 11:28:15 AM Hello, I am using Word 2003 merging data from Excel 2003. I have been using this for several years, producing invoices in word from a small database in excel for a small charity. Today for the first time when I open the invoice, say yes to the "opening this document will run the following SQL command: SELECT * FROM 'merge' " the fields appear as {MERGEFIELD . . . } and do not change when I click on the 'view merged data' tool in the mail merge tool bar. I have searched the archives but have not seen anything like this. Can anyone shed any light on this, please. Barbara

Re: View Merged data not working "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/13/2008 11:38:46 AM Click Alt-F9 and/or check the field-related options in Tools->Options->View -- Peter Jamieson http://tips.pjmsn.me.uk "Barbara Wiseman" <this.is.not[ at ]real.email.address> wrote in message news:O0Jw1XRXJHA.3808[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Hello, > I am using Word 2003 merging data from Excel 2003. > > I have been using this for several years, producing invoices in word from > a small database in excel for a small charity. > > Today for the first time when I open the invoice, say yes to the "opening > this document will run the following SQL command: SELECT * FROM 'merge' " > the fields appear as {MERGEFIELD . . . } and do not change when I click on > the 'view merged data' tool in the mail merge tool bar. > > I have searched the archives but have not seen anything like this. > Can anyone shed any light on this, please. > Barbara >

Re: View Merged data not working "Barbara Wiseman" <this.is.not[ at ]real.email.address> 12/13/2008 12:04:45 PM Peter, Thank you so much, it is so simple when you know the 2 buttons to press, Alt - F9 did the trick. I have no idea how it got changed. Yours gratefully, Barbara. "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message news:u$FLedRXJHA.5272[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Click Alt-F9 and/or check the field-related options in > Tools->Options->View > > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "Barbara Wiseman" <this.is.not[ at ]real.email.address> wrote in message > news:O0Jw1XRXJHA.3808[ at ]TK2MSFTNGP05.phx.gbl... >> Hello, >> I am using Word 2003 merging data from Excel 2003. >> >> I have been using this for several years, producing invoices in word from >> a small database in excel for a small charity. >> >> Today for the first time when I open the invoice, say yes to the "opening >> this document will run the following SQL command: SELECT * FROM 'merge' " >> the fields appear as {MERGEFIELD . . . } and do not change when I click >> on the 'view merged data' tool in the mail merge tool bar. >> >> I have searched the archives but have not seen anything like this. >> Can anyone shed any light on this, please. >> Barbara >> >

Re: View Merged data not working "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 12/13/2008 12:25:25 PM You receive the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source - http://support.microsoft.com/?kbid=825765. See also the Word macro to toggle the registry setting referred to in that link at http://www.gmayor.com/word_vba_examples.htm#SQL. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Barbara Wiseman wrote: [Quoted Text] > Hello, > I am using Word 2003 merging data from Excel 2003. > > I have been using this for several years, producing invoices in word > from a small database in excel for a small charity. > > Today for the first time when I open the invoice, say yes to the > "opening this document will run the following SQL command: SELECT * > FROM 'merge' " the fields appear as {MERGEFIELD . . . } and do not > change when I click on the 'view merged data' tool in the mail merge > tool bar. > I have searched the archives but have not seen anything like this. > Can anyone shed any light on this, please. > Barbara