View Single Post
  #1   Report Post  
mranz
 
Posts: n/a
Default Word Field Codes in Excel data file

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.