• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 8 views
  • Users 0 members are here
Related

Email Addresses in Custom Constituent Headers

Joshua Wager
$organization

Hi,

We'd like to show email addresses in our custom constituent headers and were wondering what other organizations do.

We have two concerns that have to do with inheritance and hard bounces.

Specifically - has anyone constructed a header that shows HH/A1/A2 addresses, regardless of which account you've currently selected, along with some sort of indication when one of these is bouncing?

Joshua Wager
DBA
Oregon Symphony

Parents
  • $organization

    I am currently showing jus the email address associated with that account, so no inheritance etc yet.

    But I did write code to add a strike through to the email address on the header if it was been reported as hard bouncing at least twice.

    case when exists (select 1 from T_PROMOTION (NOLOCK) where response=9 and customer_no=@customer_no and eaddress=@eaddress having COUNT(*)>2) then 'Y' else 'N' end

    Mark

Reply
  • $organization

    I am currently showing jus the email address associated with that account, so no inheritance etc yet.

    But I did write code to add a strike through to the email address on the header if it was been reported as hard bouncing at least twice.

    case when exists (select 1 from T_PROMOTION (NOLOCK) where response=9 and customer_no=@customer_no and eaddress=@eaddress having COUNT(*)>2) then 'Y' else 'N' end

    Mark

Children
No Data