query not showing up as data source from Word

[jennyc]

I wrote a query called "qyCurrentConstituent"
It selects contents of the current record from the open constituent form.
(ie "fname: forms![fmConstituent]![person first name]" etc)
(SQL looks like this: "SELECT [forms]![persons form]![person salutation] AS Sal, [forms]![persons form]![person first name] AS fname" etc)

The query works and responds with details of the active record.

I then want to send that person a letter in Word.
I go to mail merge, and want it to use this query as the data source.

When I open data sources, select the database, it shows a list of queries and tables. This query; qyCurrentConstituent is not in the list. A number of other queries are left out too - I can't see what they have in common.

I had this set up before - did I do something different for it to work last time?

Thanks in advance

 

[Pat Hartman]

Word doesn't "see" the queries that have elements that it doesn't recognize such as Access forms.

 

[jennyc]

Any Idea how i did this before???? (I know you're not a mind reader!)

but I did have the clients working for a LONG time with a standard letter template that had the address and salutation fields set up to merge from the current record on the input form.

So when they are looking at a person's record and want to send them an individual letter, they just open word and click a macro button which opens the merge letter template which picked up the contents of the query.

Trouble is, someone deleted the query - and they have rotated over the backups - so I was just recreating from scratch. If this is not how it was done, I can't remember how I did it!

 

[Pat Hartman]

The query may have prompted for a value. Or, they may have run a make table query with just the data they wanted to merge and merged from the table.

 

[jennyc]

>The query may have prompted for a value.
No - it picked up all the name and address fields of the current record, without any prompt or user input.

>Or, they may have run a make table query with just the data they wanted >to merge and merged from the table.
No - and I know that because I did originally set it up (my brain is just too full to remember anything anymore!). The Word merge doc definitly refers to the query name, and there are no macros or code anywhere in the db that would have run a make table query.

Has the new version of word got more particular about it's data sources?

Can you think of another method for getting the live data into a query?




__________________

 

[Pat Hartman]

Can you think of another method for getting the live data into a query?

- if you build the mail merge from scratch, you can choose a query and then filter it in Word. I don't know how to re-use a mail merge though.

 

[b_karv]

I had same problem...It is little bug in word but it is fixable check this thread out
http://www.access-programmers.co.uk/forums/showthread.php?t=50057&highlight=mail+merge+queries