Mail Merge Help

[Ilan]

hello,
I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
Basically in my criteria for the query i use the [ ]
operators to prompt the user for to imput a month and
year.
Now, i use a RunApp Macro to send the results of the
query to Word for a mail merge. However, when i am
setting up my main document, i cannot select my query
because it is not listed.
I believe it is not listed because it is an open
query. I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.

Does anyone have any solutions on how to get this to work?

Much appreciated,
Ilan

 

[Rsandhofer]

Ilan,
Look at in Microsofte knowledge base at article
833064 "word was unable to open the data source error
message in word mail merge when you use an access
parameter query in access 2002". When I try the method
1, I see my query. My query has multiple parameters and
I had some problems. So, I am trying method 2 - saving
to a file. I Still have other issues to work throught.
I hope the article might help you some with your problem.
Good luck.
R.Sandhofer

 

[Rsandhofer]

Ilan,
http://support.microsoft.com/default.aspx?scid=kb;en-
us;833064&Product=acc2002
if the link does not work let me know. I will try and
figure out how I found the article again or I did print
it - so I can fax it.
R

-----Original Message-----
R,
i tried to search for the article and got a message
saying: "The Knowledge Base (KB) Article You Requested
Is Currently Not Available"
do you have a link ?

Ilan

-----Original Message-----
Ilan,
In the microsoft knowledge base look at article
833604 "Word was unable to open the data source" error
message in word mail merge when you use an access
parameter query in access 2002. I have not looked at the
article in detail yet. Maybe it will help you.
Thanks again for your reply this morning.
R.Sandhofer

-----Original Message-----
hello,
I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
Basically in my criteria for the query i use the [ ]
operators to prompt the user for to imput a month and
year.
Now, i use a RunApp Macro to send the results of the
query to Word for a mail merge. However, when i am
setting up my main document, i cannot select my query
because it is not listed.
I believe it is not listed because it is an open
query. I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.

Does anyone have any solutions on how to get this to work?

Much appreciated,
Ilan
.

.

.

 

[Ilan]

I still was unable to view the article.

any help you can give me will be appreciated.

Ilan

-----Original Message-----
Ilan,
http://support.microsoft.com/default.aspx?scid=kb;en-
us;833064&Product=acc2002
if the link does not work let me know. I will try and
figure out how I found the article again or I did print
it - so I can fax it.
R

-----Original Message-----
R,
i tried to search for the article and got a message
saying: "The Knowledge Base (KB) Article You Requested
Is Currently Not Available"
do you have a link ?

Ilan

-----Original Message-----
Ilan,
In the microsoft knowledge base look at article
833604 "Word was unable to open the data source" error
message in word mail merge when you use an access
parameter query in access 2002. I have not looked at the
article in detail yet. Maybe it will help you.
Thanks again for your reply this morning.
R.Sandhofer
-----Original Message-----
hello,
I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
Basically in my criteria for the query i use the
[ ]
operators to prompt the user for to imput a month and
year.
Now, i use a RunApp Macro to send the results of
the
query to Word for a mail merge. However, when i am
setting up my main document, i cannot select my query
because it is not listed.
I believe it is not listed because it is an open
query. I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.

Does anyone have any solutions on how to get this to
work?

Much appreciated,
Ilan
.

.

.

.

 

[Graham Mayor]

The link has broken with the newsgroup settings - try
http://support.microsoft.com/?kbid=833064

This link works!
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

I still was unable to view the article.

any help you can give me will be appreciated.

Ilan

-----Original Message-----
Ilan,
http://support.microsoft.com/default.aspx?scid=kb;en-
us;833064&Product=acc2002
if the link does not work let me know. I will try and
figure out how I found the article again or I did print
it - so I can fax it.
R

-----Original Message-----
R,
i tried to search for the article and got a message
saying: "The Knowledge Base (KB) Article You Requested
Is Currently Not Available"
do you have a link ?

Ilan

-----Original Message-----
Ilan,
In the microsoft knowledge base look at article
833604 "Word was unable to open the data source" error
message in word mail merge when you use an access
parameter query in access 2002. I have not looked at the
article in detail yet. Maybe it will help you.
Thanks again for your reply this morning.
R.Sandhofer
-----Original Message-----
hello,
I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
Basically in my criteria for the query i use the [ ]
operators to prompt the user for to imput a month and
year.
Now, i use a RunApp Macro to send the results of the
query to Word for a mail merge. However, when i am
setting up my main document, i cannot select my query
because it is not listed.
I believe it is not listed because it is an open
query. I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.

Does anyone have any solutions on how to get this to work?

Much appreciated,
Ilan
.

.

.

.