If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
format of merged text
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. |
#2
|
|||
|
|||
format of merged text
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. |
#3
|
|||
|
|||
format of merged text
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 |
Thread Tools | |
Display Modes | |
|
|