Query and Mail Merge

[theKruser]

I have a form that I have created using Mail Merge. It draws from a qry in my db. When I open the qry in Access, data is displayed, yet when I hit the merge button in Word, it tells me there is not data that matches. I have verified all of the fields in the MM doc and that they all exist in the qry. I have attached a screenshot of the error message in case it helps.

Please help, as I am about to insert a stick of dynamite in my machine. Thanks in advance.

 

[jal]

I can't figure out whether you're working from Access or Word.

Doesn't one normally design the letter/ form in Word and then just use Access as a datasource? I tried this method once, and it seemed pretty straightforward. All I had to do, from the Word wizard, was browse to the DB, as I recall.

What approach are you taking?