View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mailmerge - Firstname truncate to Initial?...

You can't do this with fields. You will have to create another initial field
in your data file. This is easy enough to do in (eg) Excel.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Mark wrote:
Hi all,

I have a mail merge question, does anyone of you sage beings know how
I can truncate Firstname (MERGEFIELD Lead_PersonFirstname) to its
first initial?

I.e. instead of showing Mark Ryan, showing M Ryan instead?

Many thanks for your help!