Do you know what connection method Word is using to get the data?
If not, with your Mail merge Main document open, can you please try to start
the VBA Editor (Tools|Macro|Visual Basic Editor), look for the Immediate
window - typically at the bottom right, but if it isn't there, press
ctrl-G. Then type the following, or copy/paste it from this message, into
the Immediate window and press return to execute it
print activedocument.MailMerge.DataSource.ConnectString
then copy the result into a message in this thread.
Alternatively, if you don't have access to VBA or don't really want to go
there, can you save your document as a "Web Page" (not filtered) and close
it. Then located the .htm, and either
a. open it in Notepad or
b. check Word Tools|Options|General|"Confirm conversion at open", open the
HTML file, but choose the plain text option so you can see the HTML codes.
Then look down the file until you see
w:MailMergeConnectString
(It shouldn't be far from the top - perhaps 25-30 lines)
Does the text immediately after w:MailMergeConnectString say "DSN",
"Provider" or perhaps "Table" or "Query"?
The only circumstances I can get anything similar to what you see on my
system (with a fairly small table but some quite big memo fields) is if I
open the data source using DDE or ODBC, and it contains non-ANSI Unicode
characters. However, by default, Word uses OLE DB to connect to Access and
that particular problem would only occur if you had Unicode characters that
were not available in the relevant font. And in either case, it sounds much
more random than that. But
a. does the problem start at the same point in the field each time?
b. can you estimate how many characters are OK before the "???"
c. do your memo fields contain lots of paragraphs?
Peter Jamieson
"JKarchner" wrote in message
news
Sorry for the timely response, both are 2003.
"Peter Jamieson" wrote:
Which version of Word/Access?
Peter Jamieson
"JKarchner" wrote in message
...
I dont know what the cause of this is, but i would assume that it is
because
of a character limit. When i do a mail merge from Access from a memo
field,
after so many characters the rest of the data is displayed in "?". It
appears to be made of the same number of characters as the data, it is
just
displayed with "?"s instead of the actually character. Can anyone help
with
this?