To view original post where the Excel VBA code is explained click here.
- Prepare the spreadsheet as instructed in th ementioned above link. The article doesn't explain how to connect the macro with a button so you should have some basic knowledge on macros.
- Prepare a contact list in SharePoint.
- Since the referenced VBA code supports a certain structure of 4 columns, create calculated columns in the SP contact list that imitate the required structure. For example, concatenate the address separated by commas to get the address right.
- Export the contact list into the Address tab in the (already open) Excel spreadsheet.
- Run the macro to rearrange the addresses as label in the Label tab.
- You should see your addresses aligned in 3 columns as labels.
No comments:
Post a Comment
Enter your comment here