Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Excel Text Fields in Word
I'm using Word and Excel 2003. I have an Excel database with formatted text
in that some of the words are bold, some are italicized, etc. in the same field. I want to do a mail merge into a Word doc and maintain the same appearance of the field in Word as it appears in Excel. Now it all come over as plain text. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Excel Text Fields in Word
That is the only way that it can be done with mail merge. To maintain the
formatting, you would need to use Visual Basic to create a "roll-your-own" equivalent to mail merge. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Lollygagger" wrote in message ... I'm using Word and Excel 2003. I have an Excel database with formatted text in that some of the words are bold, some are italicized, etc. in the same field. I want to do a mail merge into a Word doc and maintain the same appearance of the field in Word as it appears in Excel. Now it all come over as plain text. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Excel Text Fields in Word
There is a "cheat" which sometimes works but should not be relied on too
much. a. copy/paste your excel data into a Word document b. use Alt-F9 to reveal your field codes. Where you need to retain the formatting, change { MERGEFIELD myfield } to { REF myfield } Peter Jamieson http://tips.pjmsn.me.uk Lollygagger wrote: I'm using Word and Excel 2003. I have an Excel database with formatted text in that some of the words are bold, some are italicized, etc. in the same field. I want to do a mail merge into a Word doc and maintain the same appearance of the field in Word as it appears in Excel. Now it all come over as plain text. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Excel Text Fields in Word
Thanks for the suggestion, but it didn't work. Would Office 2007 do what I
need? "Peter Jamieson" wrote: There is a "cheat" which sometimes works but should not be relied on too much. a. copy/paste your excel data into a Word document b. use Alt-F9 to reveal your field codes. Where you need to retain the formatting, change { MERGEFIELD myfield } to { REF myfield } Peter Jamieson http://tips.pjmsn.me.uk Lollygagger wrote: I'm using Word and Excel 2003. I have an Excel database with formatted text in that some of the words are bold, some are italicized, etc. in the same field. I want to do a mail merge into a Word doc and maintain the same appearance of the field in Word as it appears in Excel. Now it all come over as plain text. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Excel Text Fields in Word
Thanks for the suggestion. VB is a bit beyond my skill set.
"Doug Robbins - Word MVP" wrote: That is the only way that it can be done with mail merge. To maintain the formatting, you would need to use Visual Basic to create a "roll-your-own" equivalent to mail merge. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Lollygagger" wrote in message ... I'm using Word and Excel 2003. I have an Excel database with formatted text in that some of the words are bold, some are italicized, etc. in the same field. I want to do a mail merge into a Word doc and maintain the same appearance of the field in Word as it appears in Excel. Now it all come over as plain text. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting Excel Text Fields in Word
No sorry, Office 2007 is probably no different in this respect and
certainly no better. So much for "re-purposing material" :-( Peter Jamieson http://tips.pjmsn.me.uk Lollygagger wrote: Thanks for the suggestion, but it didn't work. Would Office 2007 do what I need? "Peter Jamieson" wrote: There is a "cheat" which sometimes works but should not be relied on too much. a. copy/paste your excel data into a Word document b. use Alt-F9 to reveal your field codes. Where you need to retain the formatting, change { MERGEFIELD myfield } to { REF myfield } Peter Jamieson http://tips.pjmsn.me.uk Lollygagger wrote: I'm using Word and Excel 2003. I have an Excel database with formatted text in that some of the words are bold, some are italicized, etc. in the same field. I want to do a mail merge into a Word doc and maintain the same appearance of the field in Word as it appears in Excel. Now it all come over as plain text. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting numerical fields merge from Excel | Mailmerge | |||
Text formatting in fields in a proteected form | Microsoft Word Help | |||
formatting text form fields | Microsoft Word Help | |||
formatting in text fields of word 2003 | New Users | |||
Formatting fields in Word (using Excel as Mail Merge Data) - need. | Mailmerge |