Google
Search WWW Search us
  Home   Products   Order   Download   Links   Q & A  
  Concept   Install   Step by Step   Advanced   Purchase  
 

Outlook Organizer for Excel™ provides Microsoft® Excel and Microsoft® Outlook users to execute the following functionality at ease:

  • Make a Backup of all of your Outlook PST files (and schedule it for future)
  • Build a Directory of all of your folders (Up to 5 level deep)
  • Sort all selected mails into sorted folders
  • Define Association
  • Transfer all selected mail to their Associated folder

These functionality are summarized in the following sections:


Assuming that you have Microsoft® Outlook installed on your computer as default e-mail. The Backup program allows you to select and backup your original Outlook files completely. It provide you with a reminder to make a habit of backup.

Please review the installation of the backup program here and make sure that you create a backup of your PST files before using this program. If you can not install this program, search for *.PST files and copy them to a backup location.

Once you have your backup in a safe place,  you can generate a Directory of all selected mail folders by clicking the button. The results are stored in the Setup worksheet.

Note: Program creates an outline for your data to let you show and hide levels of detail with a single mouse click. You can click the outline symbols ,, and to quickly display only the rows or columns that provide summaries or headings for sections of your worksheet, or you can use the symbols to see details under an individual summary or heading.


Assume that you are interested to organize your Inbox and Sent Items folders, then you need to select folders to be processes by the program.

You need to place an R for Received and an S for Sent in the column A of the Setup worksheet in front of the Inbox and Sent Items folders name as shown below.

Make sure that you have selected the following options in the green colored cells ( All Cells with green background indicates that the use can enter data, sometimes the green column header indicates that all cells below the header are user data entry cells).

Then click the button, and the program automatically based on your choice Moves or Copies (recommended) the mails to a newly created SORTED Folder.


For each mail a sub-folder is created with the name of the either From Name (R Option) or and the First Name in the To List (S Option)

Therefore in the Admin@Web... folder there are all mail from Admin@Web... and all mails that you have sent to this address.


Create a new PST file to organize your e-mails (Select File -> Open -> Outlook Data File... option and follow the instructions). In this example we have created a PST file called BSL Organized.

Click on the folder name and select File -> Folder and name them accordingly as show below or any other preferences.

Select one e-mail from any folder by clicking the Right Mouse Click and move it to this folder. The Run the Step [1] to renew the directory listing, make sure the new folder is displayed in the Setup worksheet.


In the column B of the spreadsheet (Alias Column) copy and paste the folder names as shown.

 

This will enable the program to associate the corresponding folder with a single name.

Add the same name for the newly created folder in the SORTED folder. Basically you are instructing the program to MOVE or COPY all e-mails in the COPY TO folder to its ALIAS folder.

Make sure that you have chosen the following parameters.

and thenclick the button. Once the program finished its work please review the newly created folders.


Once you have move enough folders to their correct destinations, you can use the Association command. To use this functionality, please place an X in column A of all folders that you would like the e-mail to be organized into.

Then click thebutton. The program will display the following message.

Check the Setup worksheet, the program automatically has set all folders within the Sort folders to their associated folders.

You just need to set the ALIAS column again, and do the step above to organize all of your e-mails.

 

 
  Home | Products | Order | Download | Links  | Services    
 
  © 2003 BaRaN Systems LLC. All rights reserved.