Mail merge to Word 2003 using Access 2003 query

[topgeek]

I have a simple database with a query that grabs all the customers from a customer table for a mail merge into Word 2003.

When I do a mailmerg from Word using the query I get norecords returned. If I do the merge direct from the table I get the records ino Word.

The query works fine in Access.


Anyone have any ideas?

 

[dhookom]

Is the query a parameter query?

Did you know that you can provide a criteria within Word?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[topgeek]

No, no parameters - it has some criteria set within the query and it returns the correct records if run from Access itself.

I was trying to set the criteria from Access, otherwise I will have to edit the users mail merge templates from Word which I was trying to avoid.

 

[dhookom]

Maybe you should share the SQL of your query so we understand it better.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jwa6]

Im working on this right now. I also have troubles w/ import if the "LIKE' is in the query

jim

 

[jwa6]

I went out to MS access help website.

http://office.microsoft.com/en-us/assistance/HP051881851033.aspx

i used the ado wildcards which does include the %. the standard access does not. it worked just fine!!!

point being this: they the MS ADO functions as well. I did - it worked. But it shouldnt have.

go figure.

jim