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 / July 2005

Tip: Looking for answers? Try searching our database.

mail merge field limit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lschmitt - 18 Jul 2005 19:34 GMT
I have a document with more fields than are allowed for one mail merge.  I
have multiple Excel source data files, most of which contain the maximum
number of columns in Excel.  I believe I need to create a series of mail
merge documents, but I can't figure out how.  How do I save one document and
change the source data without losing the original reference file?
Peter Jamieson - 19 Jul 2005 11:36 GMT
Can you clarify a bit please - as far as I know, Excel lets you have around
255 columns - are you saying that you need more columns than that, or are
you saying that you are encountering some other limitation on the number of
fields in your Word document? (If the latter, can you describe it?) Or are
you saying that merge cannot "see" all the fields in your Excel sheet?

If the answer is that you need more than 255 columns, the only way you will
be likely to get Word merge to work is to store your data in a delimited
text format instead - (most other formats also impose a limitation on the
number of fields). However, even that may not work with the current version
of Word, particularly if the number of fields is very large.

Peter Jamieson

>I have a document with more fields than are allowed for one mail merge.  I
> have multiple Excel source data files, most of which contain the maximum
> number of columns in Excel.  I believe I need to create a series of mail
> merge documents, but I can't figure out how.  How do I save one document
> and
> change the source data without losing the original reference file?
Doug Robbins - 19 Jul 2005 11:46 GMT
Must be some document!

Your only chance is going to be if you can split the mailmerge main document
into a number of separate documents that draw their mergefields from a
single spreadsheet.  You would then have to execute the merge for each main
document to a new document and then use a macro to combine the corresponding
sections from each of these documents.

Signature

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

>I have a document with more fields than are allowed for one mail merge.  I
> have multiple Excel source data files, most of which contain the maximum
> number of columns in Excel.  I believe I need to create a series of mail
> merge documents, but I can't figure out how.  How do I save one document
> and
> change the source data without losing the original reference file?

Rate this thread:






 
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.