I want the name from the first fillable field of the address block to automatically fill into the letter greeting. This is simple, and I've found various ways to accomplish this: what I can't figure out is how to have a comma autofill after the name. Does this make sense? I would rather not have a "hard coded" comma hanging out to the right of the name, or have the name justify right so that there's a gap between "Dear" and the name.
I just want the greeting to say "Dear [name autofilled from address block] , " ...I just can't figure out how to get that comma to autofill after the name.
In the calculate event, using FormCalc, insert the following formula in the scripts window:
Concat("Dear", " ",object_name,",")
Note that each item in the list of concatenated items is separated by a comma and the list must be enclosed with parentheses. When inserting straight text (instead of a field), the text must have " " on either side of the text. To insert a space use: ," ",. The object_name would be the name you gave to the object that contains the addressee's full name. Thus, we have Dear, a space, the name, and a comma immediately after the name with no space.