4 Replies Latest reply on Oct 2, 2012 5:12 AM by Colin Flashman

    Need to remove LAST NAME only in merged letter

    Mr. Met Level 3

      Here's my quandry. Client supplied a mail list with full name in column one. It's okay for the addressing portion, but in the salutation she wants to remove just the last name. I already merged my 2900 name list.


      So I have:


      Mary and John Smith

      123 Main St.

      Your Town, State Zip


      Dear Mary and John Smith,


      Then body of letter.


      I would need a way to search for any space and word before the comma and return in this one line only. Remove the space and last name so the comma slides over after John. I don't want to strip out any other words before a comma. I checked and I believe no line in the letter has a hard return following a comma.


      Doable? If so, how?