From the Tools menu in Word, select Options and then go to the General tab
and check the box against "Confirm conversions at open." After you do
this, when you attach the data source to the mail merge main document, you
will be given a number of options for the method by which the connection
should be made. Selecting the DDE option will probably overcome your
problem.

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

"calmo" wrote in message
...
I'm trying to create a mail merge doc from an Access query. Trouble is I
can't see the query I need! I've checked the properties of the query
against
others in the dbase, but there doesn't appear to be any difference. Could
it
be the number of fields in the query? There are 44?

"Doug Robbins" wrote:

The limit is mostly a function of the data-source. If it's a table in a
Word document, you will be limited to a maximum of 64 fields (columns in
the
table) though it may be less depending upon the width of the columns. If
you use Excel or Access as the data source, you are limited to 256 fields
(columns) but with a comma delimited file, that number can be exceeded.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Shauna Koppang" wrote in
message
...
Is there a maximum number of mail merge fields that can be used in one
document? If so what is that number.

Thanks!
Shauna