Currently, we have only 1 true email field that allows for additional emails to be listed in it manually. There is no way to automatically put additional emails in that list, and to also automatically send workflow emails to those additional emails.
To try and solve this, we created a text field that we call email 2. This way we are getting our contacts work and personal emails. (we need both because work is a government email and we deal with a lot of fire wall issues)
We then use the email 2 field in workflow emails in the cc option. This creates a few problems.
  1. It creates another contact record that is no longer associated to the original contact record when an email is sent out (using the cc option).
  2. When unsubscribing there is no native way to update email 2, we have to just delete it and build a whole workflow to find the other original contact record to unsubscribe that contact record as well.
  3. There is no way to merge these contact records natively, or if they come in with another email 2 from another form, it is just going to create another contact record. You see the problem- lots of duplicate contact records and no way to easily unsubscribe these emails.
Is there a way we can have another true email field, an email 2 option that isn't just a text field, and a way to compare all email fields to find duplicate contacts.
This way if we have another true email field - the unsubscribe process will be easier to build.