Merge letter no picking up my Query.

  • Thread starter Thread starter MAD
  • Start date Start date
M

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
 
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
 
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
 
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
 
Back
Top