Mail merge, Word doc, query

[Dick7Access]

I am having a problem with doing a mail merge between my main db and a word doc. The fields in the Word doc are suppose to get data from a query that only includes 10 fields. Yet when I look at insert merge field it list all the fields in the db which are many. When I try and merge it just sits there and works and works, and never competes. It’s a merge that I have done for years without a problem, but even with the old word doc and same query’s its not working. I have tried making a new query and new word doc but nothing works. Anybody have any ideas.

SELECT tblCHURCHES.LastMonth, tblCHURCHES.ThisMonth, tblCHURCHES.sorte, tblCHURCHES.txtChurch, tblCHURCHES.txtAdd, tblCHURCHES.txtCity, tblCHURCHES.txtState, tblCHURCHES.txtZip, tblCHURCHES.txtNameF, tblCHURCHES.txtNameL, tblCHURCHES.CHID
FROM tblCHURCHES
WHERE (((tblCHURCHES.sorte)="E"))
ORDER BY tblCHURCHES.txtChurch;

 

[PaulO]

Looking at what you've pasted I'd say your mailmerge doc is looking at the TABLE not the query

e.g. SELECT tblCHURCHES.LastMonth etc

 

[Dick7Access]

Looking at what you've pasted I'd say your mailmerge doc is looking at the TABLE not the query

e.g. SELECT tblCHURCHES.LastMonth etc

You are correct the doc is looking at the table, but why, it should only be looking at the query. Which I believe is the problem, as the doc merge is trying to load the entire db. Of course the sql view of the query which I posted gets it's data from the table which it has to.

 

[Dick7Access]

Lord have mercy
Problem solved. I have a back up of all my db's in a folder called safety. The icon on my desk top was going to the back up db where I was making all my changes and sort criteria. Unfortunate when I did a search for "Mailings > Select Recipients" I was going to the original db. I have since put "Back Up" after the file name so that can't happen again.