[Andy Roberts]

I cant seem to see the queries I need when I mail merge to access from Word.
I can only see one query?, even though several exist in my access database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[guzarva16]

"Andy Roberts" à¢Õ¹à»ç¹¢éͤÇÒÁ
...

[NetworkTrade]

I copied this from a MS support page and saved in a Word doc but forgot to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data Exchange
(DDE) when you attach the Access database to the mail merge document. To do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then click
Next: Starting document.
6. Under Select starting document, click the document that you want to use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from Word.
I can only see one query?, even though several exist in my access database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Andy Roberts]

Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word 2007.
I get prompted as you explained but when I click OK I get the attached
message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news
I copied this from a MS support page and saved in a Word doc but forgot to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data Exchange
(DDE) when you attach the Access database to the mail merge document. To
do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Doug Robbins - Word MVP]

Start the merge from Access. Add the "Merge it with Microsoft Office Word"
item (from the Commands not in Ribbon) to the QAT.

--
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

"Andy Roberts" wrote in message
...
Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word
2007. I get prompted as you explained but when I click OK I get the
attached message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news
I copied this from a MS support page and saved in a Word doc but forgot to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data Exchange
(DDE) when you attach the Access database to the mail merge document. To
do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Hector talero]

On 4/12/08 3:47 PM, in article , "Andy
Roberts" wrote:

Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word 2007.
I get prompted as you explained but when I click OK I get the attached
message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news
I copied this from a MS support page and saved in a Word doc but forgot to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data Exchange
(DDE) when you attach the Access database to the mail merge document. To
do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Andy Roberts]

Thanks Doug

Not quite sure what you mean by QAT. I can see one query in the mail merge
in word, just not the others (there are 5).

Andy

"Doug Robbins - Word MVP" wrote in message
...
Start the merge from Access. Add the "Merge it with Microsoft Office
Word" item (from the Commands not in Ribbon) to the QAT.

--
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

"Andy Roberts" wrote in message
...
Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word
2007. I get prompted as you explained but when I click OK I get the
attached message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news
I copied this from a MS support page and saved in a Word doc but forgot
to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a
Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data
Exchange
(DDE) when you attach the Access database to the mail merge document. To
do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click
Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Andy Roberts]

Doug

I think (having looked into it) the QAT, is the Quick Access Toolbar?

Andy

"Doug Robbins - Word MVP" wrote in message
...
Start the merge from Access. Add the "Merge it with Microsoft Office
Word" item (from the Commands not in Ribbon) to the QAT.

--
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

"Andy Roberts" wrote in message
...
Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word
2007. I get prompted as you explained but when I click OK I get the
attached message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news
I copied this from a MS support page and saved in a Word doc but forgot
to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a
Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data
Exchange
(DDE) when you attach the Access database to the mail merge document. To
do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click
Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Andy Roberts]

.... which doesn't help as I'm on Access 2003

"Doug Robbins - Word MVP" wrote in message
...
Start the merge from Access. Add the "Merge it with Microsoft Office
Word" item (from the Commands not in Ribbon) to the QAT.

--
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

"Andy Roberts" wrote in message
...
Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word
2007. I get prompted as you explained but when I click OK I get the
attached message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news
I copied this from a MS support page and saved in a Word doc but forgot
to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a
Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data
Exchange
(DDE) when you attach the Access database to the mail merge document. To
do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that you
want to use as your data source, click the database, and then click
Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy

[Doug Robbins - Word MVP]

In that case, from the Tools menu in Access, select Office Links and then
Merge it with Microsoft Office Word

--
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

"Andy Roberts" wrote in message
...
... which doesn't help as I'm on Access 2003

"Doug Robbins - Word MVP" wrote in message
...
Start the merge from Access. Add the "Merge it with Microsoft Office
Word" item (from the Commands not in Ribbon) to the QAT.

--
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

"Andy Roberts" wrote in message
...
Thanks for this. I'm using Word 2007 so the instructions are a little
different, but I managed to work out how to do the same thing in Word
2007. I get prompted as you explained but when I click OK I get the
attached message (see attached screenshot)

Any thoughts? Is it because i'm using 2007 (*.doc format not *.docx),
Access 2003, but saved as an Access 2000 format database?

Andy

"NetworkTrade" wrote in message
news I copied this from a MS support page and saved in a Word doc but forgot
to
save the url. I fixed the same problem for me:

Word- merge Query not found
SYMPTOMS
When you try to use a Microsoft Access query as the data source in a
Word
mail merge operation, some of the queries in the Access database may be
unavailable as data sources in the Mail Merge Wizard.
Back to the top
WORKAROUND
To work around this problem, confirm that Word uses Dynamic Data
Exchange
(DDE) when you attach the Access database to the mail merge document.
To do
this, follow these steps:
1. Open a new blank document.
2. On the Tools menu, click Options, and then click the General tab.
3. Click to select the Confirm conversion at Open check box, and then
click
OK.
4. On the Tools menu, point to Letters and Mailings, and then click
Mail
Merge Wizard.
5. Under Select document type, click the type that you want, and then
click
Next: Starting document.
6. Under Select starting document, click the document that you want to
use,
and then click Next: Select recipients.
7. Under Select recipients, click Use an existing list, and then click
Browse under Use an existing list.
8. Locate and open the folder that contains the Access database that
you
want to use as your data source, click the database, and then click
Open.
9. In the Confirm Data Source dialog box, click MS Access Databases via
DDE
(*.mdb, *.mde), and then click OK.
10. In the Microsoft Access dialog box, click the Queries tab, click
the
query that you want to use, and then click OK.
NOTE: All the queries in the Access database are available.

--
NTC


"Andy Roberts" wrote:

I cant seem to see the queries I need when I mail merge to access from
Word.
I can only see one query?, even though several exist in my access
database.

I can see all the tables fine. I am using Word 2007 and Access 2003.

Andy