MaxSelect allows you to import addresses from within a building into Microsoft Word or Excel. This will save you time when writing a letter to an owner/committee member or creditor.

MaxSelect Video

Set Up MaxSelect

For all versions, you must remember to return the Security Settings back to their original settings. Untick 'Trust access to Visual Basic Project', and reset the security level as desired.

Word Macro Security

You need to ensure that the PC running this function is able to run / recognise Visual Basic Project, as well as have appropriate Macro Security (All Macros Enabled) in order for the MaxSelect functions to work.

  1. Open Word.
  2. Click the File menu, then Options.
  3. Open the Trust Center options, and then click the Trust Center Settings button.

  4. In Trust Center Settings ensure that Trust access to the VBA project object model is ticked as well as Enable all macros. This can be set back to Disable all macros after the installation is complete (step 8. below). Click OK, then close the Word Options menu.

MaxSelect Installation

  1. Open MaxSelectInstall.doc, which should be located in network Drive/BCM/Setup/MaxSelectInstall.doc, or it may have the extension .docm, depending on which version of MS Office you have installed. You will then see the following:

  2. Click the button 'Install The Select Building Document Button', and the installation will begin, and add MaxSelect to the 'Add-Ins' menu in Word.

Add MaxSelect to the Word Ribbon

  1. Open Word
  2. Click the File menu, then Options.
  3. In the Word Options menu, select Customise the Ribbon.

  4. Click the Choose Commands from drop-down list on the left and select Macros.

  5. In the list on the right, select the Home menu and click the New Group button at the bottom.
  6. The new group will appears in the list, so whilst highlighted, click the Rename button at the bottom, name the group and click the OK button.

  7. Select the new group you just created in the list on the right, and then select 'Normal.MaxMacros.SelectBuilding....' in the list on the left, and click  the Add >> button in the center.
    • This will added the MaxSelect add-on to the list on the right, under your new group.

  8.  Now select the 'Normal.MaxMacros.SelectBuilding...' and click the Rename button, then choose a Symbol and enter the Display Name and click OK, then click OK again to close the Word Options window.

Using MaxSelect

Once installed and set up in Word, you can use the add-in to save or open documents. The default for saving the documents is to the building, doc folder.

  1. Open Word and click on the MaxSelect icon under the Add-Ins tab in the ribbon.
    • The name and appearance of this icon will depend on what was selected during the setup of the MaxSelect add-in (see step 8. above).
  2. The list of buildings will appear in the MaxSoft - Building Document Selection window.

  3. Select the  building and click the Insert Address or Open Document buttons.
    • You can click in the top cell of either column, and then start typing to jump to that building.
  4. Now you can select an owner’s name from the list or select the required radio button under the Select Option section in the top right (Creditors, Committee, etc.).
    • If an owner has more than one address you can then use the drop-down list in the bottom right to select from the three different addresses from within the Roll menu.

Max Select in Excel

  1. Open Word and click on the MaxSelect icon under the Add-Ins tab in the ribbon.
  2. Open MS Excel, and minimize it.
  3.  Back in the MaxSelect add-in window, a Use Excel box will now be visible.

  4. Simply tick the box, then bring Excel back on screen, and you can add names and addresses into Excel.