The original worksheet was created using a simple Export to Excel from a SharePoint list with three columns visible:
The idea was we could reuse the 2015 list for our 2016 mail-out, after adding the 30+ new clients we started working with this year. Our General Manager, Darren, asked me to track down the Excel workbook we used last year to determine which clients receive Christmas Cards and then create a mail merge to print labels with their addresses to use on the card envelopes. Here’s some back story to give it context: When using Excel today, I hit a roadblock and found a solution that I want to share.
