[HappyCampDirector]

when i merge information from an excel spreadsheet the format changes to bold
and caps. How to I get it to merge in the same format.

[macropod[_2_]]

Hi HappyCampDirector,

You're probably getting this result because that formatting is what the underlying paragraph format has (possibly via a paragraph
Style). You can impose a different format by editing the mergefield. To do this:
.. select the mergefield and press Shift-F9. You should see something like {MERGEFIELD Data} or {MERGEFIELD Data \* MERGEFORMAT},
where 'Data' is the name of the field in your data source.
.. edit the field code so that it reads {MERGEFIELD Data \* CHARFORMAT}
.. format the 'M' in 'MERGEFIELD' with the font attributes you desire.
.. run your mailmerge.

--
Cheers
macropod
[MVP - Microsoft Word]


"HappyCampDirector" wrote in message
...
when i merge information from an excel spreadsheet the format changes to bold
and caps. How to I get it to merge in the same format.

[Graham Mayor]

macropod wrote:
. format
the 'M' in 'MERGEFIELD' with the font attributes you desire. .

Or the whole field

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org