You don't need to insert the Word field in the Excel data. All you need to
do is insert the filename and/or the bookmark name of the text you want to
insert. Then call the field(s) containing this information in an Includetext
field in the merge document eg
{Includetext "C:\\path\\{Mergefield TextFile}"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



mranz wrote:
Word & Excel 2003 on XP
I have a mail merge form project that is too large for a Word table
(too many columns) and I need to use the IncludeText field code in
the data source. I could use an unformated Word text data source,
but the data for each record is so large it is next to impossible to
edit without the benefit of a table and Excel offers huge advantages
in its sort and fill functions. But I can't seem to get a Word field
code into an Excel spreadsheet. The best I seem to be able to do is
get the Word result to display in Excel, but not the field code
formula I want. Can this be done?

For what it is worth, I can get exactly what I want using Excel 4 and
Word
5.1 on Mac OS 9 by paste linking the Excel data source as unformated
text in a Word document and then using that as the Word data source
for the Word main document. You never have to open and try to edit
the Word unformated text data document. Make the change in your
Excel data document and they are automatically updated into the Word
data file.