Formatting Excel Text Fields in Word

[Lollygagger]

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.

 

[Doug Robbins - Word MVP]

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

 

[Peter Jamieson]

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]

Thanks for the suggestion, but it didn't work. Would Office 2007 do what I
need?

 

[Lollygagger]

Thanks for the suggestion. VB is a bit beyond my skill set.

 

[Peter Jamieson]

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