Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge Access to Word using a Query
WinXPPro. Office 2002 Pro. Have been using Mail Merge using Jet 4 OLE DB
Provider and it has worked fine. Need to change so that the Mail Merge uses a query in Access as its data source rather than a table. This option is not available in OLE etc. So I changed data source to OCBC DSN and I can see the queries. But... it doesn't execute the Access query... just returns the full table (not using the criteria logic of the query). I changed the query so it uses a 2nd linked table rather than a criteria... still get all the records in the main table of the query. Can anyone help? thank you, Winston |
#2
|
|||
|
|||
From the Tools menu in Word, select Options and then on the General tab,
check the box against the "Confirm conversions at open" item. After doing that, when you attach the data source to the mailmerge main document, you will be given a number of options for the method of connection. Try the different options and see if can get the desired result. -- 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 "Winston" wrote in message ... WinXPPro. Office 2002 Pro. Have been using Mail Merge using Jet 4 OLE DB Provider and it has worked fine. Need to change so that the Mail Merge uses a query in Access as its data source rather than a table. This option is not available in OLE etc. So I changed data source to OCBC DSN and I can see the queries. But... it doesn't execute the Access query... just returns the full table (not using the criteria logic of the query). I changed the query so it uses a 2nd linked table rather than a criteria... still get all the records in the main table of the query. Can anyone help? thank you, Winston |
#3
|
|||
|
|||
I tried that... didn't make any difference. Any other ideas?
thanks, Winston "Doug Robbins" wrote: From the Tools menu in Word, select Options and then on the General tab, check the box against the "Confirm conversions at open" item. After doing that, when you attach the data source to the mailmerge main document, you will be given a number of options for the method of connection. Try the different options and see if can get the desired result. -- 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 "Winston" wrote in message ... WinXPPro. Office 2002 Pro. Have been using Mail Merge using Jet 4 OLE DB Provider and it has worked fine. Need to change so that the Mail Merge uses a query in Access as its data source rather than a table. This option is not available in OLE etc. So I changed data source to OCBC DSN and I can see the queries. But... it doesn't execute the Access query... just returns the full table (not using the criteria logic of the query). I changed the query so it uses a 2nd linked table rather than a criteria... still get all the records in the main table of the query. Can anyone help? thank you, Winston |
#4
|
|||
|
|||
Winston,
What SP of Office XP do you have? I tried this same thing (Office XP Sp3 here) and it worked okay (eg, displayed the results of the query). One thought - in Access, right click at the top of the query design (the field list), click properties, see if "Output all fields" is set to yes. I don't think this would matter - it's just a guess. I'm also not certain why you say the option's not available in OLE - how are you linking Access with Word? Mike "Winston" wrote in message ... WinXPPro. Office 2002 Pro. Have been using Mail Merge using Jet 4 OLE DB Provider and it has worked fine. Need to change so that the Mail Merge uses a query in Access as its data source rather than a table. This option is not available in OLE etc. So I changed data source to OCBC DSN and I can see the queries. But... it doesn't execute the Access query... just returns the full table (not using the criteria logic of the query). I changed the query so it uses a 2nd linked table rather than a criteria... still get all the records in the main table of the query. Can anyone help? thank you, Winston |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
Envelope Address | New Users | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Cannot access outlook contacts through Word mail merge | Mailmerge | |||
How do I create & merge specific data base & master documents? | New Users |