[Bryan L]

Our CRM DB stores all phone numbers in the same (annoying) format: there can
be no space between the parenthesis and the 7-digit number. For example,
(800) 555-1212 is stored as (800)555-1212. Many of us think it looks ugly
and want that space added in when we merge Form Letters that include ph/fax
numbers. However, I haven't found a way to do this programmatically. I've
tried the obvious, like using {MERGEFIELD "UserFax" \# "(###) ###'-'####"},
but when such formatting is applied to a field, Word doesn't recognize the
field when merging, giving an "Invalid Merge Field" error that states the
merge field does not exist in the data source.

Apparently the CRM system presents the data to Word as already-formatted
text, so I've been looking for ways to parse the text of a merge field
result, but haven't found a way to accomplish this yet. In a nutshell, is
there a way I can consistently add that space into the merge field result of
all my phone number fields?

Thanks in advance,

Bryan