A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to change the font of Grid in Mail Merge Database field



 
 
Thread Tools Display Modes
  #1  
Old June 16th, 2009, 11:41 PM posted to microsoft.public.word.mailmerge.fields
jchengroup
external usenet poster
 
Posts: 1
Default 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  
Old June 17th, 2009, 05:45 AM posted to microsoft.public.word.mailmerge.fields
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default 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  
Old June 17th, 2009, 09:00 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.