This recipe shows you how export data that is accessible through a relationship. For example, you might have contacts that are employees of other contacts and you want to send all the employees a mail shot at their workplace address. Or you might want to send all members of the same household a mail shot.
In this recipe we will merge the individual contact data with household contact data to create a CSV file that we can use in a mail merge.
Search for the individuals you wish to target and select Export contacts from the actions drop-down menu at the top of the search results listing.
Click on the Select fields for export button and then set up your export fields as follows:
Save your field mapping and click on Export.