Mail merge fields formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LO - 04 May 2007 21:53 GMT

I'm creating mail merge documents. When the data is uploaded into the merge
document, the format of the merge field changes and does not match the rest
of the Word Document. I attempt to correct the text format, but as soon as
the document is printed, the format goes back to the original which does not
match the rest of the document. Not sure what I'm doing wrong.

Reply to this Message

macropod - 05 May 2007 03:05 GMT

Hi LO,

This sounds rather like the paragraph you've got the mailmerge field in is formatted with a particular Word Style, and someone has
overridden that with hard-formatting. The best way of dealing with this is to use the Style definitions correctly.

Having said that, there is a workaround:
. select the problem field
. press Shift-F9 to reveal the field coding, which should look something like: {MERGEFIELD MyData}
. format the 'M' in MERGEFIELD the way you want the output formatted
. add '\* Charformat' to the end of the field, thus: {MERGEFIELD MyData \* Charformat}
. delete the '\* Mergeformat' switch if it's present
. run your mailmerge.

Cheers

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> I'm creating mail merge documents. When the data is uploaded into the merge
> document, the format of the merge field changes and does not match the rest
> of the Word Document. I attempt to correct the text format, but as soon as
> the document is printed, the format goes back to the original which does not
> match the rest of the document. Not sure what I'm doing wrong.

Reply to this Message