Mail Merge - not seeing all queries

[R.Sandhofer]

Using an Access DB which is link to a SQL server DB. The
link files do not show up in the merge to be selected.
Though some of the queries that use the link files show
up. Not all of the queries show up - why?

 

[Ilan]

i think because your query probably is an open query
which asks the user to input something in order for the
query to run. i am having the same problem.

Ilan

 

[Guest]

Ilan,
Thanks, I had not thought of that. The query uses a form
for parameter entry. So, that might be correct. Wonder,
if there is a way around this?

 

[Ilan]

i dont know i posted also - if i find out i'll let you
know and i hope i'll do the same.

-Ilan

 

[Peter Jamieson]

Certain types of query/table do not show up when you are connecting using
OLEDB (the default method in Word 2002/2003) or ODBC. For example,
a. UNION queries
b. parameter queries
c. queries containing user-defined functions
d. queries containing certain predefined functions (Mainly financial, I
think)

Your best bet, assuming you actually have Access on the machine, is to
change the connection method to DDE (check Word
Tools|Options|General|"Confirm conversions at open", go through the
connection process again, and select DDE as the connection method.

 

[Ilan]

hello,
i received a response to my post in access.queries (etc).
it was from a gentleman who is an "MVP" who has a website
for help. The site has a sample access program which puts
a button on a form so you can press it to merge a single
record. here is the website (download the file to see how
it wokrs)
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

(ps-it works with VB modules)

Good Luck.

Ilan