Q: I just imported a list and there is nothing in the "Dear" field.
   How can I take just the first name of each contact and place it into
   the Dear field?

A. You can do this with a replace of filtered records. First, use a filter
   to select just those records you would like changed (000 for all
   records) then from the "Replace in filtered records" option of the
   "Database Utilities":

   Replace this field: US7                           ; "Dear" field
   To look like this : &SUBS(CON,1,(AT(" ",CON)-1))  ; 1st name of CON

   This command takes the first word from the CONtact field and copies it
   into the US7 field.  If you use another field for your DEAR field, 
   please substitute the correct TeleMagic field name like US3 or US5.

   END 527
   02/22/91  DRM
   indexed on: dear/replace/import