Modifying Fields Prior to Mail Merge Execution

[Jon Oestermeyer]

Hello -

I have a mail merge template created in MS Word 2003, and populated from an
excel file. The issue I have is this: the "owner" field is exported from
CRM in the following format: lastname, firstname. The customer would like
the closing of the letter to ge Firstname Lastname. I have some vba code
that will allow me to generate the Firstname Lastname text but do not know
how to add that to the macro execution and substitute the values. Any ideas
/ help would be appreciated.

Thanks.