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
|
|||
|
|||
How to change the font of Grid in Mail Merge Database field
Hi,
I currently use Mail Merge "Database" Field to read from a CSV file which will produce in a table (or a grid) in the word doc. I found that regardless what format I used, the generated table (or the grid) is always "Times New Roman" font. For example, after I inserted "Database" field in the word doc before I ran Mail Merge, I changed the font of the sample grid in the word doc to different font. Then I ran Mail Merge and the generated doc which had the final table gird was shown in Times New Roman. I also tried to use different " Table AutoFormat". The end result is still always "Times New Roman". There is an option of "Font" in "Table AutoFormat" and I don't see any difference by selecting it or not. My ultimate goal is that my base document is using "Verdana" and I need to make whatever Table (or Grid) produced by this "Database" Mail Merge field to be in the same font for consistency. But it seems that no way of making this work. Can you advise? Many thanks |
#2
|
|||
|
|||
How to change the font of Grid in Mail Merge Database field
Hi jchengroup,
In Word, add a 'Charformat' picture switch to the mergefield. To do this: .. select the mergefield; .. press Shift-F9 to expose the field coding. It should look something like {MERGEFIELD MyData}, where 'MyData' is your data field's name; .. delete everything between 'MyData' and the closing field brace; .. add ' \* Charformat' after 'MyData', so that you end up with {MERGEFIELD MyData \* Charformat}; .. format at least the 'M' in 'MERGEFIELD' with the font attributes you want; .. position the cursor anywhere in the field and press F9 to update it. .. run your mailmerge. -- Cheers macropod [Microsoft MVP - Word] "jchengroup" wrote in message ... Hi, I currently use Mail Merge "Database" Field to read from a CSV file which will produce in a table (or a grid) in the word doc. I found that regardless what format I used, the generated table (or the grid) is always "Times New Roman" font. For example, after I inserted "Database" field in the word doc before I ran Mail Merge, I changed the font of the sample grid in the word doc to different font. Then I ran Mail Merge and the generated doc which had the final table gird was shown in Times New Roman. I also tried to use different " Table AutoFormat". The end result is still always "Times New Roman". There is an option of "Font" in "Table AutoFormat" and I don't see any difference by selecting it or not. My ultimate goal is that my base document is using "Verdana" and I need to make whatever Table (or Grid) produced by this "Database" Mail Merge field to be in the same font for consistency. But it seems that no way of making this work. Can you advise? Many thanks |
#3
|
|||
|
|||
How to change the font of Grid in Mail Merge Database field
FWIW macropod's tip should also work with DATABASE fields, as you have
probably discovered. Otherwise, AIUI, a. the text formatting in DATABASE table results is based on the document's Normal paragraph style. If the entire document should be in Verdana, you should probably change the font of the Normal style to Verdana anyway. b. the checkbox for "font" in the autoformat dialog is really to select the font characteristics that are actually applied in the autoformatting, such as bolding - I don't think any of the autoformat styles actually selects a different font. Peter Jamieson http://tips.pjmsn.me.uk jchengroup wrote: Hi, I currently use Mail Merge "Database" Field to read from a CSV file which will produce in a table (or a grid) in the word doc. I found that regardless what format I used, the generated table (or the grid) is always "Times New Roman" font. For example, after I inserted "Database" field in the word doc before I ran Mail Merge, I changed the font of the sample grid in the word doc to different font. Then I ran Mail Merge and the generated doc which had the final table gird was shown in Times New Roman. I also tried to use different " Table AutoFormat". The end result is still always "Times New Roman". There is an option of "Font" in "Table AutoFormat" and I don't see any difference by selecting it or not. My ultimate goal is that my base document is using "Verdana" and I need to make whatever Table (or Grid) produced by this "Database" Mail Merge field to be in the same font for consistency. But it seems that no way of making this work. Can you advise? Many thanks |
Thread Tools | |
Display Modes | |
|
|