[Katie]

Hi,

I have the same trouble when connecting to the data source using DDE - that
is, it doesn't appear to contain all of my information in excel and does not
include some rows. Is there something else that I am doing wrong?

Kind regards,


"Doug Robbins - Word MVP" wrote:

Try connecting to the data source using DDE.

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

"Katie" wrote in message
...
Hi all,

I am wondering if someone could please help - I am lost/baffled as to what
I
may be doing wrong. I'm doing a mail merge using an excel table as my data
source. When I choose OLE DB Database Files, all of my data is selected, I
can filter accordingly and complete the mail merge. However, there are
many
cells in my worksheet which contain more than 256 characters, so these
come
across as incomplete. If I change the data source to be Excel Files via
ODBC
(*.xls,xlsx, xlsm,xlsb), then I get the full text from my excel file,
however
it appears to not include some rows and not show the information. As I
really
need all of the characters, I really need to choose the data source as
ODBC,
but I have no idea why it is not including some information from my excel
file.

Could someone please help me out? I have been through the help files and
can't find anything.