[Nancy Carol]

I have office 2002 installed.

I have created a form letter. I want to merge it with a student query in an
Access Database. When I go to get the data and try to open the Database,
nothing happens. I just go right back to the selection Menu with the Get
Data Button highlighted, but no merge button highlighted. It never lets me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

[Doug Robbins - Word MVP]

If you click on the Insert Merge Fields button, are there any merge fields
displayed? You have to have some merge fields in the document before you
can execute the merge.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" Nancy wrote in message
...
I have office 2002 installed.

I have created a form letter. I want to merge it with a student query in
an
Access Database. When I go to get the data and try to open the Database,
nothing happens. I just go right back to the selection Menu with the Get
Data Button highlighted, but no merge button highlighted. It never lets
me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

[Nancy Carol[_2_]]

No, it never opens the database to let me select the fields I ned. This is
where it just goes back to the Get Data. It ignores the request to open the
database.

Thanks for getting back to me.

Nancy Carol

"Doug Robbins - Word MVP" wrote:

If you click on the Insert Merge Fields button, are there any merge fields
displayed? You have to have some merge fields in the document before you
can execute the merge.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" Nancy wrote in message
...
I have office 2002 installed.

I have created a form letter. I want to merge it with a student query in
an
Access Database. When I go to get the data and try to open the Database,
nothing happens. I just go right back to the selection Menu with the Get
Data Button highlighted, but no merge button highlighted. It never lets
me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

.

[Doug Robbins - Word MVP]

In ToolsOptionsGeneral, check the box for the Confirm conversions at open
item and then try and re-attach the data source, trying that various methods
of connection that will be offered as a choice. The DDE option may work.

Does the query that you a trying to use ask for a parameter when you open it
in Access? If so, Word will not be able to handle that.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" wrote in message
...
No, it never opens the database to let me select the fields I ned. This
is
where it just goes back to the Get Data. It ignores the request to open
the
database.

Thanks for getting back to me.

Nancy Carol

"Doug Robbins - Word MVP" wrote:

If you click on the Insert Merge Fields button, are there any merge
fields
displayed? You have to have some merge fields in the document before you
can execute the merge.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" Nancy wrote in message
...
I have office 2002 installed.

I have created a form letter. I want to merge it with a student query
in
an
Access Database. When I go to get the data and try to open the
Database,
nothing happens. I just go right back to the selection Menu with the
Get
Data Button highlighted, but no merge button highlighted. It never
lets
me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

.

[Nancy Carol[_2_]]

Doug;

It made no difference when I checked the box. I know there must be
some kind of connection issue because it just ignores opening the database.

I even paid for someone from the AFB to assist me and he is as
confused as we all are.

Thanks for trying;

Nancy Carol

"Doug Robbins - Word MVP" wrote:

In ToolsOptionsGeneral, check the box for the Confirm conversions at open
item and then try and re-attach the data source, trying that various methods
of connection that will be offered as a choice. The DDE option may work.

Does the query that you a trying to use ask for a parameter when you open it
in Access? If so, Word will not be able to handle that.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" wrote in message
...
No, it never opens the database to let me select the fields I ned. This
is
where it just goes back to the Get Data. It ignores the request to open
the
database.

Thanks for getting back to me.

Nancy Carol

"Doug Robbins - Word MVP" wrote:

If you click on the Insert Merge Fields button, are there any merge
fields
displayed? You have to have some merge fields in the document before you
can execute the merge.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" Nancy wrote in message
...
I have office 2002 installed.

I have created a form letter. I want to merge it with a student query
in
an
Access Database. When I go to get the data and try to open the
Database,
nothing happens. I just go right back to the selection Menu with the
Get
Data Button highlighted, but no merge button highlighted. It never
lets
me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

.


.

[Peter Jamieson]

I don't have an answer either and I'm not sure the answers to the
following will help, but
a. have you been able to use this database as a mail merge data source
before?
b. is this database .mdb format?
c. is the database on a local drive or a network drive?
d. do you know whether the tables are in the .mdb itself or whether
they are all linked to another database (e.g. a SQL Server database of
some kind)
e. are you using Workgroup security (with a separate .mdw file) ?
f. if you create a new data source in Word Mailmerge and save it as a
..mdb, and put a test record in there, does that work as a data source?
g. if you also have Excel, can you make a copy of your database file
(e.g. .mdb) then try to open the copy in Excel and see what happens?


Peter Jamieson

http://tips.pjmsn.me.uk

On 01/11/2009 12:06, Nancy Carol wrote:
Doug;

It made no difference when I checked the box. I know there must be
some kind of connection issue because it just ignores opening the database.

I even paid for someone from the AFB to assist me and he is as
confused as we all are.

Thanks for trying;

Nancy Carol

"Doug Robbins - Word MVP" wrote:

In ToolsOptionsGeneral, check the box for the Confirm conversions at open
item and then try and re-attach the data source, trying that various methods
of connection that will be offered as a choice. The DDE option may work.

Does the query that you a trying to use ask for a parameter when you open it
in Access? If so, Word will not be able to handle that.

--
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, originally posted via msnews.microsoft.com
"Nancy wrote in message
...
No, it never opens the database to let me select the fields I ned. This
is
where it just goes back to the Get Data. It ignores the request to open
the
database.

Thanks for getting back to me.

Nancy Carol

"Doug Robbins - Word MVP" wrote:

If you click on the Insert Merge Fields button, are there any merge
fields
displayed? You have to have some merge fields in the document before you
can execute the merge.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol"Nancy wrote in message
...
I have office 2002 installed.

I have created a form letter. I want to merge it with a student query
in
an
Access Database. When I go to get the data and try to open the
Database,
nothing happens. I just go right back to the selection Menu with the
Get
Data Button highlighted, but no merge button highlighted. It never
lets
me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

.


.

[Doug Robbins - Word MVP]

Another thing that you can try is to initiate the mail merge from Access.
In Access, from the Tools menu, select Office Links and then Merge it with
Microsoft 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, originally posted via msnews.microsoft.com
"Nancy Carol" wrote in message
...
Doug;

It made no difference when I checked the box. I know there must be
some kind of connection issue because it just ignores opening the
database.

I even paid for someone from the AFB to assist me and he is as
confused as we all are.

Thanks for trying;

Nancy Carol

"Doug Robbins - Word MVP" wrote:

In ToolsOptionsGeneral, check the box for the Confirm conversions at
open
item and then try and re-attach the data source, trying that various
methods
of connection that will be offered as a choice. The DDE option may work.

Does the query that you a trying to use ask for a parameter when you open
it
in Access? If so, Word will not be able to handle that.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" wrote in message
...
No, it never opens the database to let me select the fields I ned.
This
is
where it just goes back to the Get Data. It ignores the request to
open
the
database.

Thanks for getting back to me.

Nancy Carol

"Doug Robbins - Word MVP" wrote:

If you click on the Insert Merge Fields button, are there any merge
fields
displayed? You have to have some merge fields in the document before
you
can execute the merge.

--
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, originally posted via msnews.microsoft.com
"Nancy Carol" Nancy wrote in message
...
I have office 2002 installed.

I have created a form letter. I want to merge it with a student
query
in
an
Access Database. When I go to get the data and try to open the
Database,
nothing happens. I just go right back to the selection Menu with
the
Get
Data Button highlighted, but no merge button highlighted. It never
lets
me
select and data from the database.

Does anyone know how I can fix this problem?

Thanks in Advance

Nancy Carol

.


.