[rshed]

Using MS Access Query as my data source, I only can merge data w/o putting
any criteria in the query. Once I ask the query to retrieve a particular
data, the query will retrieve it, but Word will not populate the data. I do
not want the client to have to use the "Mail Merge Recipients" to select a
group of clients. After the query retrieves the group selected, I want to
merge the data by simply clicking the "View Merge Data" button. I can do
this already w/o any criteria in the query, but I will end up with the whole
DB being populated in Word.

Thanks in advance for your help.

[Doug Robbins - Word MVP]

In Word, from the Tools menu, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mail merge main document,
you will be asked for the method by which the attachment should be made.
Try the various options. Probably the DDE one will allow you to do what you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o putting
any criteria in the query. Once I ask the query to retrieve a particular
data, the query will retrieve it, but Word will not populate the data. I
do
not want the client to have to use the "Mail Merge Recipients" to select a
group of clients. After the query retrieves the group selected, I want to
merge the data by simply clicking the "View Merge Data" button. I can do
this already w/o any criteria in the query, but I will end up with the
whole
DB being populated in Word.

Thanks in advance for your help.

[rshed]

Doug,
No questions were asked after I checked the "Confirm Conversion at Open"
box. Word went straight into my merge document w/o giving me the option to
choose a method.
--



"Doug Robbins - Word MVP" wrote:

In Word, from the Tools menu, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mail merge main document,
you will be asked for the method by which the attachment should be made.
Try the various options. Probably the DDE one will allow you to do what you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o putting
any criteria in the query. Once I ask the query to retrieve a particular
data, the query will retrieve it, but Word will not populate the data. I
do
not want the client to have to use the "Mail Merge Recipients" to select a
group of clients. After the query retrieves the group selected, I want to
merge the data by simply clicking the "View Merge Data" button. I can do
this already w/o any criteria in the query, but I will end up with the
whole
DB being populated in Word.

Thanks in advance for your help.

[Doug Robbins - Word MVP]

You need to re-attach the data source to get the option of how the
connection should be made.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Doug,
No questions were asked after I checked the "Confirm Conversion at Open"
box. Word went straight into my merge document w/o giving me the option
to
choose a method.
--



"Doug Robbins - Word MVP" wrote:

In Word, from the Tools menu, select Options and then go to the General
tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mail merge main
document,
you will be asked for the method by which the attachment should be made.
Try the various options. Probably the DDE one will allow you to do what
you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o
putting
any criteria in the query. Once I ask the query to retrieve a
particular
data, the query will retrieve it, but Word will not populate the data.
I
do
not want the client to have to use the "Mail Merge Recipients" to
select a
group of clients. After the query retrieves the group selected, I want
to
merge the data by simply clicking the "View Merge Data" button. I can
do
this already w/o any criteria in the query, but I will end up with the
whole
DB being populated in Word.

Thanks in advance for your help.

[rshed]

That works, but it's only a temporary fix. When I exit Word and pull the
query again for merging with Word, I get the same results (no records).
--



"Doug Robbins - Word MVP" wrote:

You need to re-attach the data source to get the option of how the
connection should be made.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Doug,
No questions were asked after I checked the "Confirm Conversion at Open"
box. Word went straight into my merge document w/o giving me the option
to
choose a method.
--



"Doug Robbins - Word MVP" wrote:

In Word, from the Tools menu, select Options and then go to the General
tab
and check the box against the "Confirm conversions at open" item. After
doing that, when you attach the data source to the mail merge main
document,
you will be asked for the method by which the attachment should be made.
Try the various options. Probably the DDE one will allow you to do what
you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o
putting
any criteria in the query. Once I ask the query to retrieve a
particular
data, the query will retrieve it, but Word will not populate the data.
I
do
not want the client to have to use the "Mail Merge Recipients" to
select a
group of clients. After the query retrieves the group selected, I want
to
merge the data by simply clicking the "View Merge Data" button. I can
do
this already w/o any criteria in the query, but I will end up with the
whole
DB being populated in Word.

Thanks in advance for your help.

[Doug Robbins - Word MVP]

Did you save the document after re-attaching the data source?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
That works, but it's only a temporary fix. When I exit Word and pull the
query again for merging with Word, I get the same results (no records).
--



"Doug Robbins - Word MVP" wrote:

You need to re-attach the data source to get the option of how the
connection should be made.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Doug,
No questions were asked after I checked the "Confirm Conversion at
Open"
box. Word went straight into my merge document w/o giving me the
option
to
choose a method.
--



"Doug Robbins - Word MVP" wrote:

In Word, from the Tools menu, select Options and then go to the
General
tab
and check the box against the "Confirm conversions at open" item.
After
doing that, when you attach the data source to the mail merge main
document,
you will be asked for the method by which the attachment should be
made.
Try the various options. Probably the DDE one will allow you to do
what
you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o
putting
any criteria in the query. Once I ask the query to retrieve a
particular
data, the query will retrieve it, but Word will not populate the
data.
I
do
not want the client to have to use the "Mail Merge Recipients" to
select a
group of clients. After the query retrieves the group selected, I
want
to
merge the data by simply clicking the "View Merge Data" button. I
can
do
this already w/o any criteria in the query, but I will end up with
the
whole
DB being populated in Word.

Thanks in advance for your help.

[rshed]

Yes
--



"Doug Robbins - Word MVP" wrote:

Did you save the document after re-attaching the data source?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
That works, but it's only a temporary fix. When I exit Word and pull the
query again for merging with Word, I get the same results (no records).
--



"Doug Robbins - Word MVP" wrote:

You need to re-attach the data source to get the option of how the
connection should be made.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Doug,
No questions were asked after I checked the "Confirm Conversion at
Open"
box. Word went straight into my merge document w/o giving me the
option
to
choose a method.
--



"Doug Robbins - Word MVP" wrote:

In Word, from the Tools menu, select Options and then go to the
General
tab
and check the box against the "Confirm conversions at open" item.
After
doing that, when you attach the data source to the mail merge main
document,
you will be asked for the method by which the attachment should be
made.
Try the various options. Probably the DDE one will allow you to do
what
you
want.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rshed" wrote in message
...
Using MS Access Query as my data source, I only can merge data w/o
putting
any criteria in the query. Once I ask the query to retrieve a
particular
data, the query will retrieve it, but Word will not populate the
data.
I
do
not want the client to have to use the "Mail Merge Recipients" to
select a
group of clients. After the query retrieves the group selected, I
want
to
merge the data by simply clicking the "View Merge Data" button. I
can
do
this already w/o any criteria in the query, but I will end up with
the
whole
DB being populated in Word.

Thanks in advance for your help.