Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Retain original formatting
Word 2003
I am trying to perform a mail merge from an Excel data source where SOME of the reords contain a field where the first character is underlined. This underline is significant. I can of course force all first characters of a mergefield to be underlined but that is not the need. How do I retain character formatting form the DATA SOURCE? -- Phil Shortell |
#2
|
|||
|
|||
I've seen one suggestion on how to do this directly from an Excel file, but
frankly, I wouldn't bother. I suggest that you try the following: a. Select/Copy/paste your Excel sheet into a Word document, choosing a format that retains the formatting you want. I think one of the options that ends up as a table will do. b. use the Word document as the data source, but instead of using MERGEFIELD fields to insert the data, use { REF } fields. In fact, you may have to go slightly further than that, e.g. if you have a field named "myname", you may need to use { myname } rather than { REF myname } If so, you need to avoid using fuield names that clash with standard Word field type names such as REF, MERGEFIELD, FILENAME, SUBJECT etc. If that works, but you need the process to be simpler than that for end users, as far as I can tell it should be possible to write a macro to do it but I don't have any code for that myself. Peter Jamieson "Phil Shortell" wrote in message ... Word 2003 I am trying to perform a mail merge from an Excel data source where SOME of the reords contain a field where the first character is underlined. This underline is significant. I can of course force all first characters of a mergefield to be underlined but that is not the need. How do I retain character formatting form the DATA SOURCE? -- Phil Shortell |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I retain formatting from an Excel Data File to a Word Merg. | Microsoft Word Help | |||
Word Templates don't retain formatting | Microsoft Word Help | |||
How to retain specific formatting in the same line after field ent | Microsoft Word Help | |||
Autotext item should retain paragraph formatting in effect at the. | Microsoft Word Help | |||
Apply Style but keep direct formatting? | New Users |