Mail Merge

S

Sheila M

The merged data is coming into my document with Bold, larger font, and
Italic. How do I make it match the font style of my document. I am using
Word 2007 and merging from Excel 2007.
 
M

macropod

Hi Sheila,

That's probably due to the underlying formatting of the surrounding text when you inserted to mergefield. You can control the
formatting by adding 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top