 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / October 2007exceeding 255 fields
Is there a way to expand the maximum number of merge fields or use multiple work sheets within an Excel workbook in a sinlge Word merge? Thank you Not really. Even with Excel 2007, which allows more than 255 columns, you can't get more than 255 when you connect to the sheet as a mailmerge data source. Your best bets are /probably/ either a. export the data to a tab-delimited format (either in a plain text file or Word file), and try using that as the data source for a merge. However, doing that from Excel is non-trivial and there are often problems with Word not recognising the data int he data source properly. Or b. instead of using Merge, use automation to get the data from your sheet and place it in "fields" that you have marked with placeholders of some kind - i.e. "roll your own merge"  SignaturePeter Jamieson http://tips.pjmsn.me.uk > Is there a way to expand the maximum number of merge fields or use > multiple > work sheets within an Excel workbook in a sinlge Word merge? > > Thank you Thank you. Using a text file did not work as Word would only use the first 255 elements. Am not certain how to accomplish this using automation but will see what I can find out. Any advice would be most appreciated. > Not really. Even with Excel 2007, which allows more than 255 columns, you > can't get more than 255 when you connect to the sheet as a mailmerge data [quoted text clipped - 14 lines] > > > > Thank you > Thank you. Using a text file did not work as Word would only use the first > 255 elements. See what happens if you check Word Tools|Options|General"Confirm conversion at open" and choose the ""Text Files" option rather than the OLE DB option when prompted. SignaturePeter Jamieson http://tips.pjmsn.me.uk > Thank you. Using a text file did not work as Word would only use the first > 255 elements. [quoted text clipped - 24 lines] >> > >> > Thank you |
Reply to this Message |
 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.