Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
I think I understand sentence 1. I have an Excel file named Excel Data. The
header record cell A1 is labled "Endorsements". Cell A2 is filled with the name of a document saved as "ALTA 9.doc". It's about a page and a half of text. I started a new Word main document, identified Excel Data as the data source, went to insert field and selected Includetext, and hit O.K. Then to the edit links menue, change, brouse and select Excel Data. {Includetext "C:\\Documents and Settings\\My Documents\\Mmerge data\\Excel Data.xls" \*Mergeformat } is the result as I am not following the instructions in your sentence 2 correctly. I am missing something. And thanks for you help for an out of date MAC user forced to the PC. "Graham Mayor" wrote: 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. |
#4
|
|||
|
|||
Hi,
Perhaps the simplest way to achieve what you're after is to copy the source area in your Excel workbook, then paste it into Word using Edit|Paste Special and choosing the 'paste link' and whatever formatting options Word offers that suits your needs. This does essentially the same as what you described for the Mac. Cheers "mranz" wrote in message news I think I understand sentence 1. I have an Excel file named Excel Data. The header record cell A1 is labled "Endorsements". Cell A2 is filled with the name of a document saved as "ALTA 9.doc". It's about a page and a half of text. I started a new Word main document, identified Excel Data as the data source, went to insert field and selected Includetext, and hit O.K. Then to the edit links menue, change, brouse and select Excel Data. {Includetext "C:\\Documents and Settings\\My Documents\\Mmerge data\\Excel Data.xls" \*Mergeformat } is the result as I am not following the instructions in your sentence 2 correctly. I am missing something. And thanks for you help for an out of date MAC user forced to the PC. "Graham Mayor" wrote: 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. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
#5
|
|||
|
|||
I may be missing something here, but the problem is getting the Includetext
instruction into Excel in the first place. In the Mac programs I mentioned you could just type the Includetext document name into the Excel date document and proceed as you described. With later iterations you can't type it; you have to use Insert/Field, select Includetext and deal with the path and document name. I thought a work around might be to create the instruction in Word and paste it into Excel, but so far all I can get is the resulting text, not the field code instruction(s) I am look for. "macropod" wrote: Hi, Perhaps the simplest way to achieve what you're after is to copy the source area in your Excel workbook, then paste it into Word using Edit|Paste Special and choosing the 'paste link' and whatever formatting options Word offers that suits your needs. This does essentially the same as what you described for the Mac. Cheers "mranz" wrote in message news I think I understand sentence 1. I have an Excel file named Excel Data. The header record cell A1 is labled "Endorsements". Cell A2 is filled with the name of a document saved as "ALTA 9.doc". It's about a page and a half of text. I started a new Word main document, identified Excel Data as the data source, went to insert field and selected Includetext, and hit O.K. Then to the edit links menue, change, brouse and select Excel Data. {Includetext "C:\\Documents and Settings\\My Documents\\Mmerge data\\Excel Data.xls" \*Mergeformat } is the result as I am not following the instructions in your sentence 2 correctly. I am missing something. And thanks for you help for an out of date MAC user forced to the PC. "Graham Mayor" wrote: 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. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004 |
#6
|
|||
|
|||
You are missing something! You are trying to call the information in the
Endorsements field of the Excel data file The field content should be {IncludeText "c:\\path to Alta 9.doc\\{Mergefield Endorsements}"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mranz wrote: I think I understand sentence 1. I have an Excel file named Excel Data. The header record cell A1 is labled "Endorsements". Cell A2 is filled with the name of a document saved as "ALTA 9.doc". It's about a page and a half of text. I started a new Word main document, identified Excel Data as the data source, went to insert field and selected Includetext, and hit O.K. Then to the edit links menue, change, brouse and select Excel Data. {Includetext "C:\\Documents and Settings\\My Documents\\Mmerge data\\Excel Data.xls" \*Mergeformat } is the result as I am not following the instructions in your sentence 2 correctly. I am missing something. And thanks for you help for an out of date MAC user forced to the PC. "Graham Mayor" wrote: 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. |
#7
|
|||
|
|||
Graham:
It's a beautiful thing. {INCLUDETEXT "C: (path to folder where ALTA 9.doc is located)\\{Mergefield Endorsements }" \*Mergeformat } works perfectly. Field codes on, you get field codes. Field codes off you get the result, the ALTA 9.doc content! Just what I wanted. At the risk of being a pig, is there a way to include a reference to more than one document in the same cell in the data source, e.g. "ALTA 9.doc and ALTA 5.doc."? That would be handy, but you can always just use more headers with more document references. Thank you so much for your help. For me, this is huge! mranz "Graham Mayor" wrote: You are missing something! You are trying to call the information in the Endorsements field of the Excel data file The field content should be {IncludeText "c:\\path to Alta 9.doc\\{Mergefield Endorsements}"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mranz wrote: I think I understand sentence 1. I have an Excel file named Excel Data. The header record cell A1 is labled "Endorsements". Cell A2 is filled with the name of a document saved as "ALTA 9.doc". It's about a page and a half of text. I started a new Word main document, identified Excel Data as the data source, went to insert field and selected Includetext, and hit O.K. Then to the edit links menue, change, brouse and select Excel Data. {Includetext "C:\\Documents and Settings\\My Documents\\Mmerge data\\Excel Data.xls" \*Mergeformat } is the result as I am not following the instructions in your sentence 2 correctly. I am missing something. And thanks for you help for an out of date MAC user forced to the PC. "Graham Mayor" wrote: 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. |
#8
|
|||
|
|||
Provided the field containing the record contains some mechanism whereby you
know which documents to associate with that record, then you can include as many texts as you wish. You will probably need a field for each text (Endorsement1, Endorsement2 etc) You may need to associate it with a conditional field(s) e.g. {IF {Mergefield fieldname} = "test" "{Includetext "c:\\path\\Alta5.doc"} {Includetext "c:\\path\\Alta9.doc"}"{Includetext "c:\\path\\Alta6.doc"}"} i.e. if the test is true add the first two documents. if false add the third. The variations on this field are flexible -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mranz wrote: Graham: It's a beautiful thing. {INCLUDETEXT "C: (path to folder where ALTA 9.doc is located)\\{Mergefield Endorsements }" \*Mergeformat } works perfectly. Field codes on, you get field codes. Field codes off you get the result, the ALTA 9.doc content! Just what I wanted. At the risk of being a pig, is there a way to include a reference to more than one document in the same cell in the data source, e.g. "ALTA 9.doc and ALTA 5.doc."? That would be handy, but you can always just use more headers with more document references. Thank you so much for your help. For me, this is huge! mranz "Graham Mayor" wrote: You are missing something! You are trying to call the information in the Endorsements field of the Excel data file The field content should be {IncludeText "c:\\path to Alta 9.doc\\{Mergefield Endorsements}"} -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mranz wrote: I think I understand sentence 1. I have an Excel file named Excel Data. The header record cell A1 is labled "Endorsements". Cell A2 is filled with the name of a document saved as "ALTA 9.doc". It's about a page and a half of text. I started a new Word main document, identified Excel Data as the data source, went to insert field and selected Includetext, and hit O.K. Then to the edit links menue, change, brouse and select Excel Data. {Includetext "C:\\Documents and Settings\\My Documents\\Mmerge data\\Excel Data.xls" \*Mergeformat } is the result as I am not following the instructions in your sentence 2 correctly. I am missing something. And thanks for you help for an out of date MAC user forced to the PC. "Graham Mayor" wrote: 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help | |||
WP Delay Code - Word Equiv | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |