Answers.Body: <ol>
  <li>Use the search builder to find contacts where email is null. Add the results to a smart group called <strong>No emails</strong></li>
  <li>Go to Advanced search </li>
  <li>In Basic Criteria, set <em>Group(s)</em> to <strong>No emails</strong></li>
  <li>In Address, set Street Address to <strong>%</strong></li>
  <li>In Relationships, set <em>Relationship Type</em> to <strong>Spouse/Partner</strong> and <em>Target Contact(s) in Group</em> to <strong>No emails</strong></li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T10:05:30.787Z
Answers.Text: I tried this first as it seemed the simplest but i kept getting an error message saying -                                                                                       Sorry but we are not able to provide this at the moment.
  DB Error: no such field
  Return to home page.???
Answers.UserDisplayName: Louise Melzack
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T16:55:58.537Z
Answers.Text: Maybe try where email is NULL rather than empty. I've tested on 4.6.2 and it's working as expected for me.
Answers.UserDisplayName: Nicholai
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-14T02:37:25.303Z
Answers.LastActivityDate: 2015-05-20T19:03:44.840Z
Answers.LastEditDate: 2015-05-20T19:03:44.840Z
Answers.UserDisplayName: Nicholai
Answers.Body: <p>Two things:</p>
  
  <ul>
  <li>if you want to only send one e-mail to a couple in a relationship who prefer to share an e-mail - whether husband/wife, married LGBT couples etc - create a new Household and add both to it, add the shared e-mail address to the Household and search Contacts in that household without an e-mail address but a postal address - like this in Search Builder -  </li>
  </ul>
  
  <p>Household Name IS NOT EMPTY ...AND...
  Email IS EMPTY '' ...AND...
  Contact Type - 'Household' . </p>
  
  <ul>
  <li>I would prefer to have an e-mail for each of a husband and a wife, each of two married partners of any gender, etc - I have my wife and I in Civi with our own separate e-mails and we are also linked to the same Household. Sending to both e-mails or just a shared e-mail for a contribution ask depends of course on the couple's preference.</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T03:29:42.570Z
Answers.Text: I think creating a household is the way civi was "designed" but to my knowledge that has to be done automatically or some code has to do it.  IMO Creating a household for everyone is a chore that often gets overlooked and turns to messy data :(
Answers.UserDisplayName: Sonicthoughts
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-14T18:20:43.113Z
Answers.Text: Actually, creating a Household is just like creating a new Contact - then you link the Household members in each Contact's Relationship tab. Tedious if you're doing a bunch manually, sure, but doable.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T18:55:21.893Z
Answers.LastActivityDate: 2015-05-12T19:03:14.677Z
Answers.LastEditDate: 2015-05-12T19:03:14.677Z
Answers.UserDisplayName: Joe McLaughlin
Answers.Body: <p>Could you try with the Relations tab in Advanced Search? If you select Advanced Search, you can click the tab Relations open and you can then search on any contacts that have an active relation to their spouse? That does not immediately solve your problem but you could separate the problematic cases from the other ones?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T10:08:31.773Z
Answers.Text: thanks - yes i can find all the people with spouse relationship - and export the data to an excel spreadsheet and then sort to see who has an email, and who has an address, but i feel there must be an easier way to do this within the system - but maybe not?!
Answers.UserDisplayName: Louise Melzack
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-15T10:40:51.103Z
Answers.Text: Apparently not :-)
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T14:42:15.407Z
Answers.LastActivityDate: 2015-05-12T14:42:15.407Z
Answers.UserDisplayName: ErikH - CiviCooP
Answers.Body: <p>What you are looking for is a common denominator, something a particular group has in common in order to include or exclude them. </p>
  
  <p>One method: If you use the Membership feature and you want only one mailing to go to one spouse, then you can include in your address search the field in the Advanced Search> Memberships> Primary Member? choose "Yes" to arrive at one address for the two related contacts. You can then mark this group (tag, activity, etc.) in order to know which ones received the postal mailing.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-13T03:30:25.780Z
Answers.Text: great suggestion, but should not require membership feature. (as you noted.)
Answers.UserDisplayName: Sonicthoughts
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-12T15:19:55.973Z
Answers.LastActivityDate: 2015-05-12T15:19:55.973Z
Answers.UserDisplayName: Beth H-C
Body: <p>I am very new to this, and am a user and work for a charity and have very little experience in this field and would really appreciate some advice!
  I want to print labels to post invitations to all our donors who we do not have an email address for. So I made a search with email address "empty" and postal address "not empty". However, if we have an email address for a husband, the mail label will still print for the wife as she has her own separate record. Does anyone know how to avoid this? I have tried editing the criteria for the search but you can't seem to search on relationships. Thanks so much Louise</p>
  
Tags: <search><relationships>
Title: Linking spouse relationship information
ThreadText: # Linking spouse relationship information
  
  (Asked by: username_0 on 2015-05-12)
  
  I am very new to this, and am a user and work for a charity and have very little experience in this field and would really appreciate some advice!
  I want to print labels to post invitations to all our donors who we do not have an email address for. So I made a search with email address "empty" and postal address "not empty". However, if we have an email address for a husband, the mail label will still print for the wife as she has her own separate record. Does anyone know how to avoid this? I have tried editing the criteria for the search but you can't seem to search on relationships. Thanks so much Louise
  
  **Tags:** search, relationships
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2015-05-14. Score: 1
  
  1. Use the search builder to find contacts where email is null. Add the results to a smart group called **No emails**
  2. Go to Advanced search
  3. In Basic Criteria, set *Group(s)* to **No emails**
  4. In Address, set Street Address to **%**
  5. In Relationships, set *Relationship Type* to **Spouse/Partner** and *Target Contact(s) in Group* to **No emails**
  
  > **Comments:**
  > **username_0**: I tried this first as it seemed the simplest but i kept getting an error message saying -                                                                                       Sorry but we are not able to provide this at the moment. DB Error: no such field Return to home page.???  
  > **username_1**: Maybe try where email is NULL rather than empty. I've tested on 4.6.2 and it's working as expected for me.  
  
  ---
  
  ### Answer by username_2 on 2015-05-12. Score: 1
  
  Two things:
  
  * if you want to only send one e-mail to a couple in a relationship who prefer to share an e-mail - whether husband/wife, married LGBT couples etc - create a new Household and add both to it, add the shared e-mail address to the Household and search Contacts in that household without an e-mail address but a postal address - like this in Search Builder -
  
  Household Name IS NOT EMPTY ...AND...
  Email IS EMPTY '' ...AND...
  Contact Type - 'Household' .
  
  * I would prefer to have an e-mail for each of a husband and a wife, each of two married partners of any gender, etc - I have my wife and I in Civi with our own separate e-mails and we are also linked to the same Household. Sending to both e-mails or just a shared e-mail for a contribution ask depends of course on the couple's preference.
  
  > **Comments:**
  > **username_3**: I think creating a household is the way civi was "designed" but to my knowledge that has to be done automatically or some code has to do it.  IMO Creating a household for everyone is a chore that often gets overlooked and turns to messy data :(  
  > **username_2**: Actually, creating a Household is just like creating a new Contact - then you link the Household members in each Contact's Relationship tab. Tedious if you're doing a bunch manually, sure, but doable.  
  
  ---
  
  ### Answer by username_4 on 2015-05-12. Score: 0
  
  Could you try with the Relations tab in Advanced Search? If you select Advanced Search, you can click the tab Relations open and you can then search on any contacts that have an active relation to their spouse? That does not immediately solve your problem but you could separate the problematic cases from the other ones?
  
  > **Comments:**
  > **username_0**: thanks - yes i can find all the people with spouse relationship - and export the data to an excel spreadsheet and then sort to see who has an email, and who has an address, but i feel there must be an easier way to do this within the system - but maybe not?!  
  > **username_4**: Apparently not :-)  
  
  ---
  
  ### Answer by username_5 on 2015-05-12. Score: 0
  
  What you are looking for is a common denominator, something a particular group has in common in order to include or exclude them.
  
  One method: If you use the Membership feature and you want only one mailing to go to one spouse, then you can include in your address search the field in the Advanced Search> Memberships> Primary Member? choose "Yes" to arrive at one address for the two related contacts. You can then mark this group (tag, activity, etc.) in order to know which ones received the postal mailing.
  
  > **Comments:**
  > **username_3**: great suggestion, but should not require membership feature. (as you noted.)  
  
  ---
  
  