Problem connecting database to word template for mailmerge

[garycoon7]

I cannot get the database to connect to the template I have designed. I have
set up the general tab for confirm conversion. Nothing seems to work.
Any help would be appreciated as I am under a deadline for these templates.
Thanks,

 

[Peter Jamieson]

I cannot get the database to connect to the template I have designed. I

have
set up the general tab for confirm conversion.

Which version of Word?

What exactly is the data source? (An Access table, Excel sheet, SQl server
table?...)

Are you seeing an error message or does Word just fail to connect and
provide no message (which it does in some cases).

Peter Jamieson

 

[garycoon7]

I have a document set up for mailmerge, the query I'm using is a parameter
query and I have checked the confirm conversion box in the general tab in the
options area.
The document cannot find the datasource, I have tried DDE, ODBC but nothing
works.
Any help would be appreciated.
Thanks

 

[Peter Jamieson]

is a parameter

query

OK,
a. presumably this is Access, with Word 2002 or 2003
b. for a parameter query, only DDE will do
c. is the database a .mdb or what? When you have selected it in "Select
Data Source" and selected the DDE option in the next dialog, do you see the
list of tables and queries? Or are you not even getting that far?
d. If you are seeing the list of tables and queries and successfully
selecting the query, what actually happens next? Do you see a dialog box pop
up anywhere so you can enter the parameter values? If not, try Alt-tab to
ensure that the dialog box has not appeared behind Word - this is a common
problem in this scenario.
e. If that's not the problem, are the underlying tables for the query in
the database, or is the query linked to external tables in some way? (I have
to say that in the latter scenario there can sometimes be problems with Word
2003).

I know you're on a deadline but I am away for a few days now - if necessary
re-post your query and point to this conversation and see if anyone else can
get any further.

Peter Jamieson