Merge letter no picking up my Query.

[MAD]

I am using Access 2003
I have a DB with names and address's of all new customers. When I am ready
to send them a "Thank You" letter for doing business with us, I have a date
field that I put in the date I will be sending them the letter. Then I have
a query that asked me for what date is in the date field that I want to use
to mail my letter to.
My merge letter is in Word. When I go to merge the letter, most of my
tables and queries show up - allowing me to pick the query that I want and to
enter the date that I want to send to. I have been doing this for 1-1/2
years, but today, for some odd reason, the exact query that I want is not
coming up in the merge. Does anyone have any idea of why this is happening?
Can anyone point me in the right direction to clear up this problem? Is
there a maximum number of queries that can be displayed when I merge the
letter?

Thank you for any help you can give me - Aurora

 

[Gina Whipp]

MAD,

Have you tried opening the query to see if perhaps it was changed somehow
and that is why it stopped showing?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am using Access 2003
I have a DB with names and address's of all new customers. When I am ready
to send them a "Thank You" letter for doing business with us, I have a date
field that I put in the date I will be sending them the letter. Then I have
a query that asked me for what date is in the date field that I want to use
to mail my letter to.
My merge letter is in Word. When I go to merge the letter, most of my
tables and queries show up - allowing me to pick the query that I want and
to
enter the date that I want to send to. I have been doing this for 1-1/2
years, but today, for some odd reason, the exact query that I want is not
coming up in the merge. Does anyone have any idea of why this is happening?
Can anyone point me in the right direction to clear up this problem? Is
there a maximum number of queries that can be displayed when I merge the
letter?

Thank you for any help you can give me - Aurora

 

[MAD]

Yes I did. when I run just the query I get just what I want. But the query
does not show up in my list to pick a query, when I try to merge my letter
with the query. do you have any other thoughts of why it does not show up?

Aurora

 

[Gina Whipp]

MAD,

Post the SQL of the query here... Just in case... go to the Query in Design
View and then press the SQL button and copy and paste what you see in that
window here.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Yes I did. when I run just the query I get just what I want. But the query
does not show up in my list to pick a query, when I try to merge my letter
with the query. do you have any other thoughts of why it does not show up?

Aurora