Merge with Excel data. Font size changes itself

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don F - 23 Aug 2003 19:57 GMT

At work using Word 97 and Excel 97 I have a merge
document using date from an Excel worksheet. The data is
in 10 pt Arial and the Word document is in 10pt Old
English Text MT. When I merge one field changes font
size to 14pt. Other merge fields are Ok and stay at 10pt
as required. The field in question is set for red text.
The OS is NT4

At home using Office XP all works OK

Anyone got any solution?

Don F

Reply to this Message

Cindy Meister -WordMVP- - 24 Aug 2003 11:57 GMT

Hi Don,

Press Alt+F9 to view field codes. Look for that particular
mergefield.

If you see \* Mergeformat in there, delete it.

Add \* CharFormat at the end of the field, in any case.

Alt+F9 again to hide the field codes.

> At work using Word 97 and Excel 97 I have a merge
> document using date from an Excel worksheet. The data is
> in 10 pt Arial and the Word document is in 10pt Old
> English Text MT. When I merge one field changes font
> size to 14pt. Other merge fields are Ok and stay at 10pt
> as required. The field in question is set for red text.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message