Cannot use querry from Access in Word
Did you have the Query open with the results of it displayed in Access when
you accessed the Tools menuOffice LinksMerge it with Microsoft Word? Does
your query produce any results?
The option that you may have changed before was either under
ToolsOptionsGeneral in versions before 2007 and check the box for Confirm
Conversion on Open (or something like that. In Word 2007, you need to click
on the Office button and then on Word Options and then on Advanced and
scroll down to the General section and check the box for Confirm File Format
Conversion on Open.
--
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, originally posted via msnews.microsoft.com
"Guy Delaney" wrote in message
...
This did not work. When it asked for the Word document, it then went back
to Access and displayed the two tables but no querries.
Guy
"Doug Robbins - Word MVP" wrote in message
...
Open the query in Access and then use the Merge it with Microsoft Word
facility available by going to the Tools menu in Access and then
selecting Office Links and then Merge it with Microsoft Word.
--
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, originally posted via msnews.microsoft.com
"Guy Delaney" wrote in message
...
I have a querry in Microsoft Access which I want to use in a Microsoft
Word mail merge, but the querry does not display in Word. (Microsoft
Office 2003).
|