Mail Merge

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

re: Mail Merge

All of your select queries should show. Action queries won't and shouldn't.

--
Duane Hookom
MS Access MVP


"Charlene" <cport@earthlink.net> wrote in message
news:uYXRb.762$GO6.522@newsread3.news.atl.earthlin k.net...[color=blue]
> I'm trying to set up a mail merge using a query out of my database for the[/color]
data[color=blue]
> source. When I browse for a data source and open my database, only a few[/color]
queries[color=blue]
> 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[/color]
one I[color=blue]
> want.
>
> Thanks!
>
> Charlene
>
>[/color]

re: Mail Merge

Thanks, Duane!

How about Union queries?

Charlene

"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
news:OJ6fhWg5DHA.2656@TK2MSFTNGP11.phx.gbl...[color=blue]
> All of your select queries should show. Action queries won't and shouldn't.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Charlene" <cport@earthlink.net> wrote in message
> news:uYXRb.762$GO6.522@newsread3.news.atl.earthlin k.net...[color=green]
> > I'm trying to set up a mail merge using a query out of my database for the[/color]
> data[color=green]
> > source. When I browse for a data source and open my database, only a few[/color]
> queries[color=green]
> > 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[/color]
> one I[color=green]
> > want.
> >
> > Thanks!
> >
> > Charlene
> >
> >[/color]
>
>[/color]

re: Mail Merge

Did you try it? When I did, the union queries were displayed.

--
Duane Hookom
Microsoft Access MVP


"Charlene" <cport@earthlink.net> wrote in message
news:tffSb.2238$GO6.2102@newsread3.news.atl.earthl ink.net...[color=blue]
> Thanks, Duane!
>
> How about Union queries?
>
> Charlene
>
> "Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message
> news:OJ6fhWg5DHA.2656@TK2MSFTNGP11.phx.gbl...[color=green]
> > All of your select queries should show. Action queries won't and[/color][/color]
shouldn't.[color=blue][color=green]
> >
> > --
> > Duane Hookom
> > MS Access MVP
> >
> >
> > "Charlene" <cport@earthlink.net> wrote in message
> > news:uYXRb.762$GO6.522@newsread3.news.atl.earthlin k.net...[color=darkred]
> > > I'm trying to set up a mail merge using a query out of my database for[/color][/color][/color]
the[color=blue][color=green]
> > data[color=darkred]
> > > source. When I browse for a data source and open my database, only a[/color][/color][/color]
few[color=blue][color=green]
> > queries[color=darkred]
> > > from the database are listed - the one I want of course is not there.[/color][/color][/color]
Does[color=blue][color=green][color=darkred]
> > > anyone know how I can list all the queries and then be able to select[/color][/color][/color]
the[color=blue][color=green]
> > one I[color=darkred]
> > > want.
> > >
> > > Thanks!
> > >
> > > Charlene
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

re: Mail Merge

Yes unless you use Parameter(s) in the Union Query.

--
HTH
Van T. Dinh
MVP (Access)



"Charlene" <cport@earthlink.net> wrote in message
news:tffSb.2238$GO6.2102@newsread3.news.atl.earthl ink.net...[color=blue]
> Thanks, Duane!
>
> How about Union queries?
>
> Charlene
>[/color]

re: Mail Merge

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" <VanT.Dinh@discussions.microsoft.com> wrote in message
news:e6igmor5DHA.3308@TK2MSFTNGP11.phx.gbl...[color=blue]
> Yes unless you use Parameter(s) in the Union Query.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Charlene" <cport@earthlink.net> wrote in message
> news:tffSb.2238$GO6.2102@newsread3.news.atl.earthl ink.net...[color=green]
> > Thanks, Duane!
> >
> > How about Union queries?
> >
> > Charlene
> >[/color]
>
>[/color]

re: Mail Merge

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" <cport@earthlink.net> wrote in message
news:sNpSb.2480$jH6.2436@newsread1.news.atl.earthl ink.net...[color=blue]
> Van,
>
> Thanks for the response!
>
> Very interesting! I experience a problem anytime I use a parameter whether[/color]
it's[color=blue]
> a simple select , union or whatever. What is your reasoning it mentioning
> Parameters as a problem?
>
> Charlene
>[/color]