Finding First Name of Affilliate 1 in Household?

Hi,

We would like to send emails to ticket buying households and our marketing department is really set on having the first name salutation.  The issue I'm having is that we keep the ticket history on the household, so the list criteria is pulling those records, but the First Name field, that I have in output set pulls blank data for households since there is no First Name in household records.

Has anyone figured out a way (aside from creating a separate salutation) to create an output set criteria with the first name field from the A1 or the A2 affiliate of the household? 

Thanks,

Tiffany

Parents
  • When I pull lists for e-mails, I make a list of the household and individual accounts that have the ticketing, contribution, constituency, or other information that makes them relevant for the message I am sending. I then add all primary affiliates to the list and pull e-mails (and names) from those affiliates. This works only if e-mails are attached to individuals, not households, of course.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FGO_logo_one_line_2color_web.jpg

Reply
  • When I pull lists for e-mails, I make a list of the household and individual accounts that have the ticketing, contribution, constituency, or other information that makes them relevant for the message I am sending. I then add all primary affiliates to the list and pull e-mails (and names) from those affiliates. This works only if e-mails are attached to individuals, not households, of course.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FGO_logo_one_line_2color_web.jpg

Children
No Data