Hi everyone,
My organization has two control-grouped email types, and an uncontrol-grouped fallback type shared by our consortium. Some people have one email of each type, some have two of one type with different (or the same) values, etc. We would like to send an email to a list, only sending once per constituent, but with an email type priority, e.g.: if they have type 1, use it, if they don't then use type 2, if they don't have that then use the primary email address.
The hangup is that if I import the list once using email type 1 in the output set, then import it again using a different output set, it will add any unique email value regardless of whether the constituent ID has already imported, so constituents will receive an email at every address we have recorded.
Has anyone been through this? Any insight would be wonderful. Thanks!
<![if !supportLists]>· <![endif]>Accounts with email type 1
<![if !supportLists]>· <![endif]>Accounts with email type 2
<![if !supportLists]>· <![endif]>Accounts with primary e-mail
<![if !supportLists]>· <![endif]>The first time, suppress the segments with type 2 and primary e-mails, so the only list pulled is accounts with type 1.
<![if !supportLists]>· <![endif]>The second time, suppress the segments with type 1 and primary, so the only list pulled is accounts with type 2 who don’t have type 1.
<![if !supportLists]>· <![endif]>The third time, suppress the segments with types 1 and 2, so the only list pulled is accounts with primary who don’t have types 1 or 2.
<![if !supportLists]>· <![endif]>Households, and individuals within a household: You have to treat each individual e-mail address as its own account, for the purpose of e-mail. Let’s say you have an A1 member of a household who has a type 1 e-mail, and the household itself has a primary e-mail. You have to decide whether you will suppress the household and any members of the household who have different types of e-mail if one member of the household has a type 1.
<![if !supportLists]>· <![endif]>Duplicate e-mail addresses. I would assume that your mail program will mail to each e-mail address only once, so I would upload the segments to your program in the order you pull the lists so that duplicates will get filtered out, and the priority of your e-mail types gets preserved.
Lucie SpielerIT Dev. & Training Manager
Hi Lucie, thanks a lot for the suggestion! The only problem with this is needing to run an extraction three times to send an email, but I can't think of a better way. Really appreciate it!