Parameter Queries and Mailmerge to Word

[Liz Jordan]

Hi

I have a letter in Word that I wish to mail-merge with data in Access. I
have a query in Access that selects the records that I want. This query is
a parameter query. I am using XP versions

I open the letter in word but when I run the mail-merge wizard in Word and
ask to attach to the Access database, only the whole database is offered to
me, not the queries.

In previous versions of Word/Access this was not the case and this would
have been a simple task.

Any ideas anyone?

Thanks in advance

Liz

 

[Noel]

Hi. Im using XP and Access 2002. In my case, after
starting the MM Wizard in the Word document, you answer
various general questions then you are asked to specify
the data source. I find using Browse easiest at this
point. Once you select the source mdb, you are asked for
any passwords that may be relevant and the connection
protocol (ie DDE), then the database is opened and you
are presented with a box that allows you to select from a
range of Tables and Queries. What exactly is
happening/not happening in your case? Noel

 

[Albert D. Kallal]

I did not think they changed that much in terms of the wizard.

You might try my word merge example I have at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html


The above is quite nice for merging stuff to work, and you could give it a
try....

 

[Liz Jordan]

I did not think they changed that much in terms of the wizard.

You might try my word merge example I have at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html


The above is quite nice for merging stuff to work, and you could give it a
try....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn

Thanks Albert but I really wanted to use a parameter query.

Liz

 

[Liz Jordan]

Hi. Im using XP and Access 2002. In my case, after
starting the MM Wizard in the Word document, you answer
various general questions then you are asked to specify
the data source. I find using Browse easiest at this
point. Once you select the source mdb, you are asked for
any passwords that may be relevant and the connection
protocol (ie DDE), then the database is opened and you
are presented with a box that allows you to select from a
range of Tables and Queries. What exactly is
happening/not happening in your case? Noel

Hi Noel

I have a table set up in Access. There are two queries on this. One is an
ordinary query that selects a certain set of records. The other is a
parameter query that will allow me to enter a value.

When we get to the MM step where we select a source, we use browse and find
the mdb source. The database opens and the table and the ordinary query is
offered to us but not the parameter query.

Any ideas? I have some screen shots of the problem but don't want to post
them here as it is usually frowned upon.

Liz

 

[Albert D. Kallal]

Ok...just through my example *might* be of use.

You can use parameters query with my example...

 

[Noel]

Hi Liz. Ive just modified one of my queries to Parameter
type and successfully created a MM doc linked to it. It
appeared in the list of queries just like all the rest.
The only small problem I encountered was when I clicked
on the query name to select it and didnt realise that a
hidden window was sitting waiting for me to enter the
parameter. I have no idea why your parameter query is not
showing. Perhaps you could try modifying , to parameter
type, one of the queries that does show. If that still
shows on your list then theres something wrong with your
original query. Strange though. Dont wish to affend but
are you absolutely sure you are selecting the correct mdb
when browsing? Cheers, Noel

 

[Liz Jordan]

Hi Liz. Ive just modified one of my queries to Parameter
type and successfully created a MM doc linked to it. It
appeared in the list of queries just like all the rest.
The only small problem I encountered was when I clicked
on the query name to select it and didnt realise that a
hidden window was sitting waiting for me to enter the
parameter. I have no idea why your parameter query is not
showing. Perhaps you could try modifying , to parameter
type, one of the queries that does show. If that still
shows on your list then theres something wrong with your
original query. Strange though. Dont wish to affend but
are you absolutely sure you are selecting the correct mdb
when browsing? Cheers, Noel

Hi Noel

Don't worry not offended. I am choosing the right mdb. I also know about
the hidden window and it wasn't that. You led me to the answer tho' when
you said something in your original post about DDE. When I was choosing the
mdb I didn't have to answer anything about DDE. So I went searching. I
eventually found the solution. In Tools, Options, General tab I checked
the option to Confirm conversion on Open. (It was unchecked by default.)
Then when I selected the mdb, I was given some choices. One of them was
the DDE option so I picked it. Lo and behold! I was offered the parameter
query.

So, thanks for the help

Liz

 

[Noel]

Glad to be of some help. Cheers, Noel

-----Original Message-----



Hi Noel

Don't worry not offended. I am choosing the right mdb. I also know about
the hidden window and it wasn't that. You led me to the answer tho' when
you said something in your original post about DDE. When I was choosing the
mdb I didn't have to answer anything about DDE. So I went searching. I
eventually found the solution. In Tools, Options, General tab I checked
the option to Confirm conversion on Open. (It was unchecked by default.)
Then when I selected the mdb, I was given some choices. One of them was
the DDE option so I picked it. Lo and behold! I was offered the parameter
query.

So, thanks for the help

Liz


.