Mail Merge Access to Word using a Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Winston - 03 May 2005 17:09 GMT

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 to this Message

Doug Robbins - 03 May 2005 19:04 GMT

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.

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

> 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
[quoted text clipped - 12 lines]
> thank you,
> Winston

Reply to this Message

Winston - 03 May 2005 19:59 GMT

I tried that... didn't make any difference. Any other ideas?
thanks,
Winston

> 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
[quoted text clipped - 18 lines]
> > thank you,
> > Winston

Reply to this Message

Mike - 04 May 2005 21:17 GMT

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

> 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
[quoted text clipped - 6 lines]
> thank you,
> Winston

Reply to this Message