Create an Individual Relationships export instead and select the appropriate fields from the Constituent Address node.
Copy the address from the relationship's constituent address to the relationship record's address section, either manually or through Address Linking.
If the relationship has been reciprocated on the relationships' constituent records:
- Create a Constituent query of the relationships' constituent records. For instance, if you need to export the addresses for constituents who have a relationship with Company A, within a constituent query, filter on Relationships, Organizations, Specific Organization Record equals Company A.
- Use the constituent query in a constituent export to export the addresses from the relationships' constituent records.
If the relationship is a Contact with a specific Contact Type:
- Create a Constituent query of the records that have the contact relationships. For example, if querying on records with contact relationships that have a specific contact type, we can add the following Criteria:
Relationships, Contacts, Contact Type equals [type]
- In Quick Letters in Mail, convert this Constituent query to a Relationship query.
NOTE: This groups together all relationships, including the specific contacts as well as any other contacts and relationships, into a Relationship query.
- Then, using Quick Letters again, convert the Relationship query created in step #2 back to a Constituent query.
NOTE: This gives us a Constituent query of all the relationships of the constituents grouped in step #1.
- Open the Constituent query created in step #3. On the Criteria tab, add the following:
Relationships, Organizations, Contact Type equals [type].
NOTE: This gives a final list of only those records who are the specific Contact Type and is pulling their constituent records.
- Create a Constituent export and export the desired constituent address.