Page Comparison

To export the property data and identify the current status of the MRA properties within OnlineRME follow these steps:

Process One: Export Data from OnlineRME:

1. Login to OnlineRME
2. Select Reports:
   
3. From the drop-down list select "Property & Last Inspection Export:
   
4. Click the  button.
5. Your file will download as an .xls export.  
   
   
   

Process Two: Working with the Data in Microsoft Excel.

1. Open the previously downloaded file in Microsoft Excel.

2. Sort the data by column G (AssignmentArea) and column R (LastInspDate).  
   
   

   Info
   title Note:
   Depending upon the version of Excel you are using, the buttons may be found in different locations.  The following is just an example, utilizing a version of Microsoft Excel.

   
   
   

   1. Locate the sort function button: 
      
      
      
   2. Select custom sort:
      
      
      

   3. Add 2 levels.  1st by AssignmentArea, Second by LastInspDate:
      

      Info
      title Note:
      For the LastInspDate, be sure to change the Order to "Newest to Oldest". This will make it so that you can quickly select the properties that you wish to be part of your group.

      
      
      

   4. Run the filter, by clicking the  button.
       
      
3. All of your data will now be sorted with the Marine Recovery Area properties at the top of the list:
   Image RemovedImage Added
4. And the inspections will be sorted by most recent inspections:
   
5. Now if you wish you limit your data set to just the MRA Properties, select the properties by hi-lighting the appropriate rows:
   Image Removed, to create a mailing list for the MRA of properties that are not in compliance, go to the most recent inspection date that is OK, then select the rows that you want to copy (out of compliance sites):   
   Image Added
6. Click control + C (Copy)
7. Open a new spreadsheet.
8. Click the top, left block in the column/row section which will automatically highlight your entire new spreadsheet:
   
9. Click control + V (Paste)
10. Your data will be copied to a clean sheet.

...

...

With this new export you can now create a mail merge document in Word.  Note - properties missing the mailing address will be excluded in the mail merge.  You can verify the missing property mailing addresses within the XLS file.  Also - don't forget!  Your mail merge will need to point to your new sheet - not the referenced main sheet.