View Single Post
  #1   Report Post  
Mark Ainsworth
 
Posts: n/a
Default Splitting text from mail merge fields

I would like to pick up just a specific word, e.g. the first word, from the
contents of a Word mail merge field.
For example, if the mail merge field contains the name in the format
"LastName, FirstName", I want to just display the lastname.

Is there a way of doing this in a mail merge field? If not, is there a way
to call a custom macro from a field so that the formatting of the field can
be performed while the mail merge is executing?

Many thanks,
Mark