My mailmerge document in Word 2002 displays the linked query field's index
number and not the data (Access 2002). How would i fix this?
Doug Robbins - Word MVP - 12 Oct 2006 04:36 GMT
If the information that you see is enclosed inside { }, then:
1. You are looking at the mailmerge main document and the display of
field codes is toggled on (Alt+F9)
2. You have not executed the merge, but are just pre-viewing the results.
You must execute the merge to a New Document or the Printer to see the data
from each of the records.
Turn on the display of the Mail Merge toolbar by selecting Toolbars from the
View menu and then check the Mail Merge item. Then use the buttons on the
right hand end of the toolbar to execute the merge to the desired
destination.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> My mailmerge document in Word 2002 displays the linked query field's index
> number and not the data (Access 2002). How would i fix this?
Peter Jamieson - 12 Oct 2006 08:43 GMT
I have seen this before and I suspect that the only ways to get around are
likely to be
a. change the way Word is connecting to Access (check Word
Tools|Option|General|"Confirm conversions at open, go through the connection
process again and choose DDE or ODBC. No use if you're using Unicde data.
b. "it is to create a "real" query in Access with the necessary inner joins
(or use old-style "WHERE maintable.lookupkey = lookuptable.lookupkey) and
use that as the data source.
I don't know for sure that either approach will work.
Peter Jamieson
> My mailmerge document in Word 2002 displays the linked query field's index
> number and not the data (Access 2002). How would i fix this?