I have a form letter. The form letter uses the usual fields, like FirstName, LastName, Address, City, State, and Zip. I want to pull the information that will popluate these fields from an access xp db called "merge.mdb"
In merge.mdb, I have a saved query, called qryCompany which filters all records where the field CompanyName = "CompanyA" from a table called tblMainTable. There are 300 or so records that match this criteria.
The problem seems to be that in word XP when I set the data source to be qryCompany in Merge.mdb and plop the fields into my form letter, absolutely no data populates my form letter. The record counter says "0".
Oddly enough, if I choose the underlying table (tblMainTable) as the data source, the form letter works perfectly.
What's the deal here? It always worked perfectly in 97/2000 versions. Whenever I perform it in these versions with these same files everything is fine - did something change? Can't you add data directly from saved access query into a merge document?
I read thru the help screens, but they seem to indicate that you can in fact do this - but I cannot figure it out.
Can anyone tell me what the deal is - maybe it's an access issue.
Thank you. How much more water would there be in the ocean if it weren't for sponges?
In merge.mdb, I have a saved query, called qryCompany which filters all records where the field CompanyName = "CompanyA" from a table called tblMainTable. There are 300 or so records that match this criteria.
The problem seems to be that in word XP when I set the data source to be qryCompany in Merge.mdb and plop the fields into my form letter, absolutely no data populates my form letter. The record counter says "0".
Oddly enough, if I choose the underlying table (tblMainTable) as the data source, the form letter works perfectly.
What's the deal here? It always worked perfectly in 97/2000 versions. Whenever I perform it in these versions with these same files everything is fine - did something change? Can't you add data directly from saved access query into a merge document?
I read thru the help screens, but they seem to indicate that you can in fact do this - but I cannot figure it out.
Can anyone tell me what the deal is - maybe it's an access issue.
Thank you. How much more water would there be in the ocean if it weren't for sponges?