H
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.
and caps. How to I get it to merge in the same format.
M
macropod
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.
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.
G
Graham Mayor
macropod said:
Or the whole field
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>