HPaulsen wrote:One of the wards in our stake doesn't have local mail delivery, so everyone has a PO Box for their mailing. The clerk has put in separate physical and mailing addresses, which is a nice feature of MLS. Unfortunately, the only way to retrieve the mailing addresses is through the "File->Print Mailing Labels" menu item. We cannot even create a custom report to show the mailing addresses in addition to the physical!
If anyone knows a solution that we haven't figured out....
The mailing address is included in the Membership Data Export (in MLS, do File > Export). This does require an MLS administrative account, and it includes confidential information that needs to be treated carefully, but it is certainly an option if you take proper precautions.
The Membership Data Export generates a Comma-Separated Values file called Membership.csv. You can load this CSV file into a spreadsheet, where you will see that columns R-X are the mailing address (columns K-Q are the home address). Unfortunately, the Membership Data Export lists individuals, not households, but it is easy enough to filter the list to include only rows that have a Head of Household (column F).
Once you have the CSV file organized the way you want it, you can use a word processor to merge that file into whatever file you want (letters, labels, etc.).
You never indicated precisely what problem you were trying to solve; there was a reference to HT/VT reports, and another to custom reports, so I don't know if this export solution would be helpful, but it might be an option.