Parameter queries not available for merging

[Creeker]

Can anyone tell me why Access database parameter queries are not available for merging into a Word document. Most the the tables are not available for merging either. We have recently upgraded to XP and the merge features are driving me crazy.

Even when I merged with a non-parameter query in the database, the data was incorrect when using the Word merge query feature. I had to resort to pasting the results of the query into a spreadsheet and merge with the spreadsheet data.

 

[lupins46]

The Word merge process was redesigned fpr OfficeXP and the default connection changed from DDE to OLEDB.
It is still possible to connect using DDE if you change a setting in Word. From memory you need to check the setting for 'Confirm Conversion on Open' in Tools>Options.
Then when you create your merge document you will be able to show all connection methods and choose the DDE option.

I haven't had any problems with mailmerge producing wrong results so can't help with that.

 

[Creeker]

That's great. Now I can see all the available queries. The trouble is that now it has me in a loop. After I link to the file and choose the query, it says it can't find the source file even though it just opened the database file. I'm in an endless loop, opening the database file over and over but never merging the data.

 

[psemianonymous]

Shameless promotion time:

'Native' mailmerge reports - as painless as possible faq181-5088


Assuming you're comfortable with building a WHERE clause of an SQL statement, this built-and-tested-and-it-works-I-swear-it module runs the mailmerge more like a report and allows you to pass in any valid SQL statement to export. You could replace your parameter queries with a base query and something like "SELECT * FROM qryBaseQuery WHERE Field1 = 'Froot Loops'".

I swear that if you spend the time to set this up, my mailmerge code is worth it.