The admin office needed to have
an excel spreadsheet of homeowner addresses to send postcards for an annual meeting.
Initially the request was for address labels. However, the print shop
wanted to use a file to print the names and addresses directly to the
postcard, not to an address label.
Using the Member Labels by Ownership report I could retrieve the
billing address which I couldn't by using the Property Ownership Details
report. I also tried different reports in the Membership module with
less than stellar results.
The Member Labels by Ownership report can be exported to an excel
spreadsheet but the layout is simply the same 3 across label formation
that Avery labels use, just dropping them into excel cells. Not very
useful as there are 3+ lines in each excel cell.
Normally I would use Text-to-Columns but the line breaks in the individual cells are problematic and don't fit the usual rules.
Ctrl+J to the rescue -
https://trumpexcel.com/split-multiple-lines/
Since there were 3 columns I separated them into 3 separate
worksheets, split the data into columns and then copied and pasted
sheets 2 and 3 to the end of sheet 1 after reviewing and cleaning up the
few 4-line addresses.
