Access/Word 2007 parameter query merge

[Wally''s Dad]

In Office 2000 I used several mail merge .doc files (read-only) based on an
Access parameter query to produce individual letters based on the ID supplied
to the query before firing up the Word document. I recently converted the
Access 2000 .mdb to the 2007 .accdb format. Now each time I try to open a
listed Word document, the following error appears:
“4605: This method or property is not available because the document is not
a mail merge documentâ€
After clicking OK either .doc, .docx or dotx documents can open but only one
record appears. When I then try to run Word 2007’s Mailings>Start Mail
Merge>Step by Step Mail Merge Wizard, at Step #3 by clicking Browse I can
navigate to the .accdb database but no parameter querys appear in the list of
the Select Table window even though they exist in the database.
I tried removing the [Enter publisher's NameID] entry from the Criteria of
my query. The query then appears in the list of the Select Table window… but
obviously, the resulting document has not narrowed down my recipients to the
ID I want to create the letter for.
So, my question is: Is it possible to open a mail-merge document based on a
parameter query in Office 2007? If so, how?
I am running English Office 2007 Ultimate SP1 on English Vista Ultimate SP1.
If it matters, Office Language Pack 2007 Chinese-(Taiwan) Traditional is also
installed but the database data is all in English.
Thanks!

 

[Doug Robbins - Word MVP]

Click on the Office Button, then on Word Options, and then on Advanced and
scroll down to the General section of the dialog and check the box against
the item "Confirm file format conversion at open". Then when you attach the
data source to the mail merge main document, select the DDE option for the
method by which the data source should be attached.

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

 

[Wally''s Dad]

Thank you Doug for your reply. Just a quick question before I proceed:
The Confirm Data Source window lists the following 3 possible DDE choices
when I check the Show All check box:
MS Access Databases via DDE (*.mdb;*.mde)
MS Excel Worksheets via DDE (*.xls)
MS Query Files via DDE (*.qry;*.dqy)

Below those is MS Access Databases via ODBC (*.mdb;*.accdb)
Which do I pick?

Click on the Office Button, then on Word Options, and then on Advanced and
scroll down to the General section of the dialog and check the box against
the item "Confirm file format conversion at open". Then when you attach the
data source to the mail merge main document, select the DDE option for the
method by which the data source should be attached.

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

In Office 2000 I used several mail merge .doc files (read-only) based on
an
Access parameter query to produce individual letters based on the ID
supplied
to the query before firing up the Word document. I recently converted the
Access 2000 .mdb to the 2007 .accdb format. Now each time I try to open a
listed Word document, the following error appears:
"4605: This method or property is not available because the document is
not
a mail merge document"
After clicking OK either .doc, .docx or dotx documents can open but only
one
record appears. When I then try to run Word 2007's Mailings>Start Mail
Merge>Step by Step Mail Merge Wizard, at Step #3 by clicking Browse I can
navigate to the .accdb database but no parameter querys appear in the list
of
the Select Table window even though they exist in the database.
I tried removing the [Enter publisher's NameID] entry from the Criteria of
my query. The query then appears in the list of the Select Table window.
but
obviously, the resulting document has not narrowed down my recipients to
the
ID I want to create the letter for.
So, my question is: Is it possible to open a mail-merge document based on
a
parameter query in Office 2007? If so, how?
I am running English Office 2007 Ultimate SP1 on English Vista Ultimate
SP1.
If it matters, Office Language Pack 2007 Chinese-(Taiwan) Traditional is
also
installed but the database data is all in English.
Thanks!

 

[Doug Robbins - Word MVP]

As your data is coming from Access, use MS Access Databases via DDE
(*.mdb;*.mde)


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

Thank you Doug for your reply. Just a quick question before I proceed:
The Confirm Data Source window lists the following 3 possible DDE choices
when I check the Show All check box:
MS Access Databases via DDE (*.mdb;*.mde)
MS Excel Worksheets via DDE (*.xls)
MS Query Files via DDE (*.qry;*.dqy)

Below those is MS Access Databases via ODBC (*.mdb;*.accdb)
Which do I pick?

Click on the Office Button, then on Word Options, and then on Advanced
and
scroll down to the General section of the dialog and check the box
against
the item "Confirm file format conversion at open". Then when you attach
the
data source to the mail merge main document, select the DDE option for
the
method by which the data source should be attached.

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

In Office 2000 I used several mail merge .doc files (read-only) based
on
an
Access parameter query to produce individual letters based on the ID
supplied
to the query before firing up the Word document. I recently converted
the
Access 2000 .mdb to the 2007 .accdb format. Now each time I try to open
a
listed Word document, the following error appears:
"4605: This method or property is not available because the document is
not
a mail merge document"
After clicking OK either .doc, .docx or dotx documents can open but
only
one
record appears. When I then try to run Word 2007's Mailings>Start Mail
Merge>Step by Step Mail Merge Wizard, at Step #3 by clicking Browse I
can
navigate to the .accdb database but no parameter querys appear in the
list
of
the Select Table window even though they exist in the database.
I tried removing the [Enter publisher's NameID] entry from the Criteria
of
my query. The query then appears in the list of the Select Table
window.
but
obviously, the resulting document has not narrowed down my recipients
to
the
ID I want to create the letter for.
So, my question is: Is it possible to open a mail-merge document based
on
a
parameter query in Office 2007? If so, how?
I am running English Office 2007 Ultimate SP1 on English Vista Ultimate
SP1.
If it matters, Office Language Pack 2007 Chinese-(Taiwan) Traditional
is
also
installed but the database data is all in English.
Thanks!

 

[Wally''s Dad]

Thank you Doug!

As your data is coming from Access, use MS Access Databases via DDE
(*.mdb;*.mde)


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

Thank you Doug for your reply. Just a quick question before I proceed:
The Confirm Data Source window lists the following 3 possible DDE choices
when I check the Show All check box:
MS Access Databases via DDE (*.mdb;*.mde)
MS Excel Worksheets via DDE (*.xls)
MS Query Files via DDE (*.qry;*.dqy)

Below those is MS Access Databases via ODBC (*.mdb;*.accdb)
Which do I pick?

Click on the Office Button, then on Word Options, and then on Advanced
and
scroll down to the General section of the dialog and check the box
against
the item "Confirm file format conversion at open". Then when you attach
the
data source to the mail merge main document, select the DDE option for
the
method by which the data source should be attached.

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

In Office 2000 I used several mail merge .doc files (read-only) based
on
an
Access parameter query to produce individual letters based on the ID
supplied
to the query before firing up the Word document. I recently converted
the
Access 2000 .mdb to the 2007 .accdb format. Now each time I try to open
a
listed Word document, the following error appears:
"4605: This method or property is not available because the document is
not
a mail merge document"
After clicking OK either .doc, .docx or dotx documents can open but
only
one
record appears. When I then try to run Word 2007's Mailings>Start Mail
Merge>Step by Step Mail Merge Wizard, at Step #3 by clicking Browse I
can
navigate to the .accdb database but no parameter querys appear in the
list
of
the Select Table window even though they exist in the database.
I tried removing the [Enter publisher's NameID] entry from the Criteria
of
my query. The query then appears in the list of the Select Table
window.
but
obviously, the resulting document has not narrowed down my recipients
to
the
ID I want to create the letter for.
So, my question is: Is it possible to open a mail-merge document based
on
a
parameter query in Office 2007? If so, how?
I am running English Office 2007 Ultimate SP1 on English Vista Ultimate
SP1.
If it matters, Office Language Pack 2007 Chinese-(Taiwan) Traditional
is
also
installed but the database data is all in English.
Thanks!