Hi,
Does anyone have a script that creates salutations based on the first name of the primary affiliate of a household?
For example: John and Linda Smith Household
Salutation: John
I know how to create salutations in the individual record manually but I don't know how to en-masse assign the first name salutation to a household.
Any help would be greatly appreciated. :)
Tiffany,
We do have a utility procedure to rebuild salutations en masse, UP_REBUILD_SALUTATIONS. This procedure accepts a list and salutation type as parameters to filter. If you have your tokens setup correctly for the salutations to generate correctly (when you create a new household or Gen Sal on an existing household it does the right thing) then you can create a list of households to update and run it through this procedure. You will want to run this in your Test system first to make sure it does what you expect. Note that this procedure doesn't add new salutation rows it only recalculates the salutation for constituents on the list with that salutation type. Note also that if you run this procedure with no parameters it will recalculate all the salutations in the system.
New version tidbit: this utility procedure has been added to the Reports and Utilities menu in the Data Management folder in v12.5.
Best,
Anna