Hello:
I'm seeking advice to find best practices for adding and maintaining addressee/salutations with education class year data for all years as part of a constituent's data for mailing lists with certain caveats. For example, one solution would be to pull all data out of RE and add this information once as an additional addressee salutation. However, constituents could earn more degrees after their first. How would I find those constituents to update their records with the new graduation year? To complicate this further, our management team would like us to use their graduation year(s) only if their preferred address is their home. If their preferred address is business, we would only use their name. Is anyone doing this currently?
Any advice or solutions would be most appreciated.