Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Fonts changing when merging data
I have data in an Excel 2003 spreadsheet that is formatted in a particular
font (Times 12pt). I am trying to mail merge that data into a Word 2003 letter that has been formatted with the same font (Times 12pt). After the merge operation the merged data from Excel is in an Ariel 10 pt font and the rest of the letter is till in Times 12pt. I have read a former post that says to "add the \* Charformat switch to the merge fields in the mail merge main document and apply the formatting that you want to the first character in the mergefield." I'm having a bad brain day......... Can someone tell me exactly what that means? I have been merging data for years and have never seen the \* Charformat switch so I don't know where to find it and I'm not exactly sure where to put it or how to use it. TIA Chuck |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Fonts changing when merging data
Press Alt+F9 to toggle on the display of field codes and you will see
{ MERGEFIELD fieldname } Add \* charformat inside the closing } so that the field becomes { MERGEFIELD fieldname \* charformat } and apply the formatting to the M (or the whole) of MERGEFIELD. -- 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 "Chuck Jurgens" wrote in message . net... I have data in an Excel 2003 spreadsheet that is formatted in a particular font (Times 12pt). I am trying to mail merge that data into a Word 2003 letter that has been formatted with the same font (Times 12pt). After the merge operation the merged data from Excel is in an Ariel 10 pt font and the rest of the letter is till in Times 12pt. I have read a former post that says to "add the \* Charformat switch to the merge fields in the mail merge main document and apply the formatting that you want to the first character in the mergefield." I'm having a bad brain day......... Can someone tell me exactly what that means? I have been merging data for years and have never seen the \* Charformat switch so I don't know where to find it and I'm not exactly sure where to put it or how to use it. TIA Chuck |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get Word 2003 to keep data file with mail merge main documen | Mailmerge | |||
Merging data into several forms | Mailmerge | |||
Edit data source icon when mail merging in Word 2003 | Mailmerge | |||
MS Word merging data into a single document from Database | Mailmerge | |||
Merging hyper link from data source | Mailmerge |