Mail Merge

[Charlene]

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

[Duane Hookom]

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

[Charlene]

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

[Duane Hookom]

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

[Van T. Dinh]

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

[Charlene]

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

[Van T. Dinh]

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