1 Reply Latest reply on May 9, 2016 3:53 PM by fenjas29325284

    Mail Merge for Cover Letter Names with Titles and Without

    Russell PROCOPY Level 1

      This is a mail merge that has a condition. It is a cover letter so it starts with "Dear" as exampled below.

      screen shot.png

      As you can see the Dear obviously is static and the title, F_name, L_name are all variables. Now there has to be a space between Dear and the title as well as between each of the other data field which brings me to my problem. If the addressees name does not begin with a title I end up with two spaces after Dear instead of one. Is there a way to make the spaces after each data field conditional based on weather the field is empty or not?

       

      Thanks!