How do I export all of the members’ CONTACT INFO (Addresses, Phones, Emails, etc)
- How do I export all of the member’s contact info?
- Login to the WordPress Admin Site for BOL. OR go to the MembershipWorks website directly at https://membershipworks.com/admin/#myaccount
- If on the BOL Admin Site, on the top left side, click on Membership Works
- Enter your Membership Works login information, which is different than your other login information
- On the left side, click on Members
- Click on Export
- Select the following columns:
- Name
- (DO NOT SELECT THE EMAIL COLUMN UNDER NAME)
- Address
- Phone
- Fax
- Summer Home Has Mail
- Include This Profile in Paper
- Everything from summeraddress through emailaddress5
- propertynumbers
- displayname
- firstname
- lastname
- Click on Download
- Click on the Excel file that opens on the bottom left
- Expand, and Highlight all columns
- Click Data/Sort
- Click My data has headers
- In the sorting tool, Sort by whatever fields you want (probably Last Name and First Name)
- Click OK
- Save as an Excel File
- Optional: Highlight the top row and make it grey and bold (Highlight top row, Right Click , Format Cells, Fill = Dark Grey, Font = Bold)
- Optional: Freeze the top row (View, Freeze Panes, Freeze Top Row)