Updating Additional Addresses and Salutations Field

Fernando Leite

Hello everyone. I need to update an additional salutation field called "Formal Invitation". Only a few people have that field (they were manually done one by one). The rest does not have anything, so I would need to create a new "Additional salutation". The "Formal Invitation" type is already there, but would need to be chosen (in the program, you can click the arrow and see the list of possible types, and Formal Invitation is one of them). And then I would have to update the salutation itself based on each individual

My problem is that I cannot find that object. How can I refer to the specific field that I need? I looked into the tables in hope I could use an SQL statement to update it but I simply cannot find it.

If anyone knows where I can refer to the "Additional Addresses and Salutations" Field, and if the easiest way to update every record is through an SQL statement or through VBA codes, please help

Thank you, Fernando

Helen Wieger

Fernando Leite:

Hello everyone. I need to update an additional salutation field called "Formal Invitation". Only a few people have that field (they were manually done one by one). The rest does not have anything, so I would need to create a new "Additional salutation". The "Formal Invitation" type is already there, but would need to be chosen (in the program, you can click the arrow and see the list of possible types, and Formal Invitation is one of them). And then I would have to update the salutation itself based on each individual

My problem is that I cannot find that object. How can I refer to the specific field that I need? I looked into the tables in hope I could use an SQL statement to update it but I simply cannot find it.

If anyone knows where I can refer to the "Additional Addresses and Salutations" Field, and if the easiest way to update every record is through an SQL statement or through VBA codes, please help

Thank you, Fernando

I recently did a large update of additional addressees and salutations. If everyone is getting the same addressee/salutation, it's easiest to add it using the Global Change, Constituent process under Admin. If constituents need different adds/sals based on nickname, marital status, or some other factor, I would either group constituents (query) according to the adds/sal they need, then use the Global Change for each group (query). If there are a lot of variables, and each constituent needs to be examined individually, I would export the pertinent fields and add/sal (if it's there), then import after making the appropriate changes. (But this latter way might be more easily done through SQL or VBA)