Limit on size of datasource?

[Lisa]

I am using office 2003 and merging a large excel
spreadsheet into a word document.

I have used mail merge several time before with no
problems with the datasources. However this time I am
using an excel spreadsheet which takes up alot of memory.
When I use the mailmerge wizard to select the source I get
to the point where I choose the worksheet I want and click
ok. Then nothing happens - no error warning or anything.
When I try to merge with the same excel file but select a
tab with a much smaller amount of data in I can merge that
fine. Is this likely to be caused by the large size of the
particular worksheet? If so can anybody tell me the size
limit and anyway workaround other than splitting up the
worksheet?

Thanks,

Lisa

 

[Cindy M -WordMVP-]

Hi Lisa,

I've never encountered the problem before, but the size is
certainly a possibility. You might try merging using an older
connection method. Active the "Confirm conversions on open"
option in Tools/Options/General. When you select the xls
workbook you'll get a listing of connection methods. Try
everything (except OLE DB, which is the default). If you get
any results, I'd be interested in knowing more.

I am using office 2003 and merging a large excel
spreadsheet into a word document.

I have used mail merge several time before with no
problems with the datasources. However this time I am
using an excel spreadsheet which takes up alot of memory.
When I use the mailmerge wizard to select the source I get
to the point where I choose the worksheet I want and click
ok. Then nothing happens - no error warning or anything.
When I try to merge with the same excel file but select a
tab with a much smaller amount of data in I can merge that
fine. Is this likely to be caused by the large size of the
particular worksheet? If so can anybody tell me the size
limit and anyway workaround other than splitting up the
worksheet?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail