View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Thicklizzie Thicklizzie is offline
external usenet poster
 
Posts: 2
Default suppressing part of a text field in a merged document

I am mail merging from an Access database and one of the fields contains full
names (e.g. Mary Smith, Michael Jones, etc.) I want the merged document to
show just the first name (e.g. Dear Mary or Dear Michael).

I cannot change how the information is entered in the Access database and
this information is already change by a "Mid([ReferalName],11,55)" in the
query.