Mail Merge


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.


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
.. 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