Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Font Changes When Data is Merged
I have data stored in an Excel spreadsheet that I am merging into a Word
document. My Word document is in Human Light Cond font, as is the code for the Mergefield. Then, when I actually merge the data, the font of the merged field changes to Human Black Cond. I can highlight the data and change the font to Human Light Cond, but it does not preserve the font when I merge the data. The following is an example of the code: { MERGEFIELD EndPremiumChange \* MERGEFORMAT } where EndPremiumChange is my variable from Excel. Appreciate any help, |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Font Changes When Data is Merged
Hi Ben,
This sounds like you may have 'hard formatted' the characters in the Human Light Cond font, but the paragraph style uses the Human Black Cond font. If so, correcting the paragraph style should solve the problem. Alternatively, select the 'M' in 'MERGEFIELD' and format that in the Human Light Cond font and change the '\* MERGEFORMAT' switch to '\* CHARFORMAT'. Cheers -- macropod [MVP - Microsoft Word] "Ben Schaum" wrote in message ... I have data stored in an Excel spreadsheet that I am merging into a Word document. My Word document is in Human Light Cond font, as is the code for the Mergefield. Then, when I actually merge the data, the font of the merged field changes to Human Black Cond. I can highlight the data and change the font to Human Light Cond, but it does not preserve the font when I merge the data. The following is an example of the code: { MERGEFIELD EndPremiumChange \* MERGEFORMAT } where EndPremiumChange is my variable from Excel. Appreciate any help, |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Font Changes When Data is Merged
Could you please explain how I would correct the paragraph style?
Thanks, "macropod" wrote: Hi Ben, This sounds like you may have 'hard formatted' the characters in the Human Light Cond font, but the paragraph style uses the Human Black Cond font. If so, correcting the paragraph style should solve the problem. Alternatively, select the 'M' in 'MERGEFIELD' and format that in the Human Light Cond font and change the '\* MERGEFORMAT' switch to '\* CHARFORMAT'. Cheers -- macropod [MVP - Microsoft Word] "Ben Schaum" wrote in message ... I have data stored in an Excel spreadsheet that I am merging into a Word document. My Word document is in Human Light Cond font, as is the code for the Mergefield. Then, when I actually merge the data, the font of the merged field changes to Human Black Cond. I can highlight the data and change the font to Human Light Cond, but it does not preserve the font when I merge the data. The following is an example of the code: { MERGEFIELD EndPremiumChange \* MERGEFORMAT } where EndPremiumChange is my variable from Excel. Appreciate any help, |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Font Changes When Data is Merged
Select the end of paragraph mark (¶) and then from the Format menu, select
Style, then click on Modify and then on Format and select Font. -- 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 "Ben Schaum" wrote in message ... Could you please explain how I would correct the paragraph style? Thanks, "macropod" wrote: Hi Ben, This sounds like you may have 'hard formatted' the characters in the Human Light Cond font, but the paragraph style uses the Human Black Cond font. If so, correcting the paragraph style should solve the problem. Alternatively, select the 'M' in 'MERGEFIELD' and format that in the Human Light Cond font and change the '\* MERGEFORMAT' switch to '\* CHARFORMAT'. Cheers -- macropod [MVP - Microsoft Word] "Ben Schaum" wrote in message ... I have data stored in an Excel spreadsheet that I am merging into a Word document. My Word document is in Human Light Cond font, as is the code for the Mergefield. Then, when I actually merge the data, the font of the merged field changes to Human Black Cond. I can highlight the data and change the font to Human Light Cond, but it does not preserve the font when I merge the data. The following is an example of the code: { MERGEFIELD EndPremiumChange \* MERGEFORMAT } where EndPremiumChange is my variable from Excel. Appreciate any help, |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data selected but not showing on merged document | Mailmerge | |||
Font box on format bar --is it supposed to be wysiwyg?? | Microsoft Word Help | |||
Help! Merged data is wrong | Mailmerge | |||
Deleting Old Versions of Fonts | Microsoft Word Help | |||
Default font - possible bulletproof fix in Word 2003 | Microsoft Word Help |