By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

Mail Merge

P: n/a
I'm trying to set up a mail merge using a query out of my database for the data
source. When I browse for a data source and open my database, only a few queries
from the database are listed - the one I want of course is not there. Does
anyone know how I can list all the queries and then be able to select the one I
want.

Thanks!

Charlene
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
All of your select queries should show. Action queries won't and shouldn't.

--
Duane Hookom
MS Access MVP
"Charlene" <cp***@earthlink.net> wrote in message
news:uY***************@newsread3.news.atl.earthlin k.net...
I'm trying to set up a mail merge using a query out of my database for the data source. When I browse for a data source and open my database, only a few queries from the database are listed - the one I want of course is not there. Does
anyone know how I can list all the queries and then be able to select the one I want.

Thanks!

Charlene

Nov 12 '05 #2

P: n/a
Thanks, Duane!

How about Union queries?

Charlene

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:OJ**************@TK2MSFTNGP11.phx.gbl...
All of your select queries should show. Action queries won't and shouldn't.

--
Duane Hookom
MS Access MVP
"Charlene" <cp***@earthlink.net> wrote in message
news:uY***************@newsread3.news.atl.earthlin k.net...
I'm trying to set up a mail merge using a query out of my database for the

data
source. When I browse for a data source and open my database, only a few

queries
from the database are listed - the one I want of course is not there. Does
anyone know how I can list all the queries and then be able to select the

one I
want.

Thanks!

Charlene


Nov 12 '05 #3

P: n/a
Did you try it? When I did, the union queries were displayed.

--
Duane Hookom
Microsoft Access MVP
"Charlene" <cp***@earthlink.net> wrote in message
news:tf*****************@newsread3.news.atl.earthl ink.net...
Thanks, Duane!

How about Union queries?

Charlene

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:OJ**************@TK2MSFTNGP11.phx.gbl...
All of your select queries should show. Action queries won't and shouldn't.
--
Duane Hookom
MS Access MVP
"Charlene" <cp***@earthlink.net> wrote in message
news:uY***************@newsread3.news.atl.earthlin k.net...
I'm trying to set up a mail merge using a query out of my database for the
data
source. When I browse for a data source and open my database, only a
few queries
from the database are listed - the one I want of course is not there.
Does anyone know how I can list all the queries and then be able to select

the one I
want.

Thanks!

Charlene



Nov 12 '05 #4

P: n/a
Yes unless you use Parameter(s) in the Union Query.

--
HTH
Van T. Dinh
MVP (Access)

"Charlene" <cp***@earthlink.net> wrote in message
news:tf*****************@newsread3.news.atl.earthl ink.net...
Thanks, Duane!

How about Union queries?

Charlene

Nov 12 '05 #5

P: n/a
Van,

Thanks for the response!

Very interesting! I experience a problem anytime I use a parameter whether it's
a simple select , union or whatever. What is your reasoning it mentioning
Parameters as a problem?

Charlene
"Van T. Dinh" <Va*******@discussions.microsoft.com> wrote in message
news:e6**************@TK2MSFTNGP11.phx.gbl...
Yes unless you use Parameter(s) in the Union Query.

--
HTH
Van T. Dinh
MVP (Access)

"Charlene" <cp***@earthlink.net> wrote in message
news:tf*****************@newsread3.news.atl.earthl ink.net...
Thanks, Duane!

How about Union queries?

Charlene


Nov 12 '05 #6

P: n/a
I am not sure the reason(s) why Microsoft won't make the Parameter Queries
available for MailMerge.

*My guess* is that the GUI required for Parameter Dialog is a function of
Access and Query processing is a function of JET. Since JET is more or less
a"shared" service in Windows, it is available for Word MailMerge. Since
Parameter Dialog is a function of Access (which may or may not be in the
memory when you run MailMerge), there is nothing to process the required
Parameter Dialog and hence Parameter Queries cannot be used and therefore
not available / visible.

--
HTH
Van T. Dinh
MVP (Access)

"Charlene" <cp***@earthlink.net> wrote in message
news:sN*****************@newsread1.news.atl.earthl ink.net...
Van,

Thanks for the response!

Very interesting! I experience a problem anytime I use a parameter whether it's a simple select , union or whatever. What is your reasoning it mentioning
Parameters as a problem?

Charlene

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.