How can I edit the format of a mail merge field after it has been.

[J]

I have a project where the datasource for a mailmerge cannot be modified.
The customer can enter a complete middlename but on the merge document they
only want to see the first letter and a period. (Enter Lee but want to see
L.) When merge is clicked a new document is created.

How can I modify a mergefield after the merge has occured?

Thanks-J

 

[Doug Robbins]

Manually.

However, if there's a lot to be done, execute the merge to a catalog (or in
Word XP and later) directory type mailmerge where you have a one row table
in the main document with each mergefield in a cell of that table. Execute
that merge to a new documnet, then select the table that is created and copy
and paste it into Excel, and then use a formula in Excel to get the first
character of the middlename and add a period to it and then copy that
formula down for each row in the data source. Add some field names as the
first row in that spreadsheet and then use it as the data source

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP