Household mailouts

[Chris Burgess]

I'd like to generate a list of households for a mailout, to send one mail per household to each member in a given electorate.

 * I need to query against the member's electorate (a custom data field, but similar to the state)
 * I would like to only send one letter to each household
 * I'd like to address the household, not a particular individual

Eg, my partner's name is "Saira", so rather than a letter addressed to one or the other of us, I'd like to send a letter addressed to

  Chris and Saira,
  174 Opanuku Road
  Waiatarua, 0612

If I search for contacts, then print labels, I get two labels in my results. If I search for households with the electorate, I get no results.

Can I perform a search for "households with members who have quality X" using the Advanced Search screen?

The "Chris & Saira" part can probably be done via the household nickname field. I can't see how to get the household details into the primary contact fields returned in the mailing labels though.

I think it may be time for me to get CiviReport running

[Donald Lobo]

yes, time to dust off and start using your java knowledge with BIRT et al

Using advanced search u can say:

Give me all the contacts who are in electorate X and have a household relationship (but this gives u the contact and not the household)

Writing the sql and using BIRT to generate the report might be easiest. Or you could build a custom module on top of civi for this specific query (and some parameters)

lobo