| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Cannot use querry from Access in Word
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). |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Cannot use querry from Access in Word
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). |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Cannot use querry from Access in Word
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). |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Cannot use querry from Access in Word
By the way, the last time I did this (a couple of years ago), I changed some
Preferences or something in Word so as to choose something other than OLE db, I think. 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). |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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). |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Cannot use querry from Access in Word
Do what Doug says re. confirm conversions, then select the DDE option
when it is offered. Peter Jamieson http://tips.pjmsn.me.uk On 26/01/2010 01:53, Guy Delaney wrote: By the way, the last time I did this (a couple of years ago), I changed some Preferences or something in Word so as to choose something other than OLE db, I think. Guy "Doug Robbins - Word 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 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). |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot see Access querry in Microsoft word | New Users | |||
| Inability to see queries in complicated access files: 2003 access& | Mailmerge | |||
| querry in word | New Users | |||
| can't access my word files - access restricted | Microsoft Word Help | |||
| word opens access in mail merge. Access is already opened.=twice | Mailmerge | |||
![Guy Delaney[_2_] is offline](images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
