Using Left, Mid, and other string stuff in Mail Merge Fields

[Shay]

I have a mail merge field «EndorsementTemplate» which gives a file name with
its extention. I however only want to display the text without the extention.
is there a way to use say Left function on the «EndorsementTemplate» field
eg. Left([EndorsementTemplate],Len([EndorsementTemplate])-4.3)

 

[Cindy Meister]

Unfortunately, no. Word provides no string manipulation functionality in its
field codes. You need to work with the strings before mail merge receives
them. Usually, this is best done in the data source file (unfortunately, you
don't mention what the data source is). Sometimes, it can be done by changing
the SQL used to pick up the data (if the data source program supports the
necessary functions).

-- Cindy