Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2004

Tip: Looking for answers? Try searching our database.

Limit on size of datasource?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 05 Oct 2004 22:17 GMT
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- - 31 Oct 2004 11:05 GMT
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.  
[quoted text clipped - 11 lines]
> 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 :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.