View Merged data not working

[Barbara Wiseman]

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

 

[Peter Jamieson]

Click Alt-F9 and/or check the field-related options in Tools->Options->View

 

[Barbara Wiseman]

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.

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>