CiviCRM Community Forums (archive)

I am trying to generate a nicely formatted a membership roster. Using the mailing labels, "Merge labels for contacts with the same address" I get ALMOST exactly what I want. However, it only provides the email address and phone number of the first contact. Thus, I get something like:

Bob & Sandy Smith
Their address
Bob's phone number
Bob's email address

Is there any way to get both Bob and Sandy's email addresses to print on the label?

Alternatively, I would love to see the resulting query that is being used to generate the labels so that I could use that as a starting point for creating my own custom search and output. 

I tried this:

{contact.contact_name}
{contact.street_address}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}
{contact.phone}
{contact.email}
{contact.spouse_email} <-- I added this line in the dim hopes it would work but alas...