Re: Mail merge from access Database

By default, Word 2003 (which is what you are using) uses a thing called OLE DB to connect to the Access database. In that case, as you say, it displays a dialog box titled Select Table. however, both Access tables and Access Queries are listed in that dialog box, although Queries are described as Views.

So you /may/ be able to select your query in there.

However, OLE DB does not "see" all types of table and query. For example, it does not "see" queries that have parameters, or queries that use user-defined Access VBA functions.

To get the most complete list of queries (and indeed, to see a cler separation between "Tables" and "Queries", you have to change the way that Word connects to Access.

To do that,
a. check Word->Tools->Options->general->Confirm conversions at open,
b. go through the process of connecting to your database again.
c. After you have selected the database in "Select Data Source" and clicked Open, you should see an additional dialog box. Select the "MS Access Databases via DDE" option and proceed.

This requires that you have Access on your system (OLE DB does not) and suffers from some limitations, but is probably what you need. NB, if you are using a Paramter Query as a data source, the dialog box that prompts for the parameters will probably pop up behind your Word window, in which case it can look as if Word is not connecting. Use e.g. Alt-Tab to go and look for it.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"TD" <TD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:0C64106D-D154-4227-82D0-B1E2CDD41A12@xxxxxxxxxxxxxxxx
Hi everybdy,

I'm trying to create a mailmerge from data in an MS Access Database. I've
come across this problem before but someone else solved it :-(.

When I've browsed and the dialogue box has come up, I'm expecting it to ask
me which query I want to select before moving on to select recipients. It
doesn't it goes straight to Select Table.

At my last job, a couple of years ago, a colleague had the correct set up
and our computer support team were able to sort me out using that
information. It was something to do with the versions of Word and Access but
probably much more complicated than that!

I'm using Word Version 11.5604.5606
Access Version 11.5614.5606

Those version numbers look spookily similar so I'm guessing nothing to do
with versions. Maybe setup???

As you can see - I need help!

Most grateful if anyone could

Cheers
--
TD

.

Relevant Pages

  • Re: Do I understand form optimization correctly?
    ... queries on an Access database. ... Access is file based, not server based. ... If you run any query on the table, the entire table is brought down to ...
    (comp.databases.ms-access)
  • Re: Problems encountered with mail merge
    ... When I pick my query and carry on with the next step, ... There may be several reasons why an OLEDB connection could fail, ... OLEDB does not "see" some query types (such as parameter queries) ... I have an access database with tables, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Do I understand form optimization correctly?
    ... > queries on an Access database. ... Access is file based, not server based. ... and the query is executed. ...
    (comp.databases.ms-access)
  • Re: Not all data sources showing
    ... Some query types won't show (Union queries, and Parameter queries) when you connect with the default method in Word 2003, which is OLE DB. ... The problem with parameter queries OLE DB is that OLE DB itself has no mechanism to prompt for the parameters, and nor does Word - with DDE, Access does it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Query Slow - Intermittent!!!
    ... To be honest, a cross tab of 21,000 records taking a minute is already ... you post the SQL of the base query and the crosstab? ... I've never come across intermittently slow queries. ... The access database is on the ...
    (microsoft.public.access.queries)