D
DAB
Hi;
In access 2000-2003 it was possible to use the Mail Merge function in
Word to access a query that has criteria required for input. You can select
the Word document and then the database is opened and the criteria box is
opened for input (Enter Parameter Value). This then produces the data for
the letters. It used a DDE connection between Word and Access. In Office
2007 the mail merge help document says to go to the Access database and
select the query and lists how to link to an existing or new letter. The DDE
connection is listed but does not attach to the query? It always comes back
with no data or just two records which are not in the query. Any help would
be appreciated.
In access 2000-2003 it was possible to use the Mail Merge function in
Word to access a query that has criteria required for input. You can select
the Word document and then the database is opened and the criteria box is
opened for input (Enter Parameter Value). This then produces the data for
the letters. It used a DDE connection between Word and Access. In Office
2007 the mail merge help document says to go to the Access database and
select the query and lists how to link to an existing or new letter. The DDE
connection is listed but does not attach to the query? It always comes back
with no data or just two records which are not in the query. Any help would
be appreciated.