Help – Website Support – Admins – How to Export all of the Members’ Contact Information

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)