HOME

• <<Back to Excel Add-ins
• <<Back to Excel Add-ins List
• <<Back to Categories
• <<Home

The File & E-Mail Assistant  $24.95 Payment Problems?

Order online from our secure service - Get delivery in minutes!
Order Risk Free - Money back guarantee if not satisfied
FREE CD - just e-mail your order confirmation to [email protected] - no shipping or handling! Buy individually or as part of the Analysis Collection for Microsoft Excel and save! Over 70%by buying 27time saving add-ins and 3downloadable books!The File and E-Mail Assistant�for Microsoft Excel

• Keeps track of the last 100 files that you have opened
• Allows you to open any of these files without searching through your folders and network drives
• Allows you to go to any file's directory either via the Windows Explorer or via Excel's file open dialog
• Makes it easier to E-mail files from your e-mail programs

If you are using Excel 97 or Excel 2000, the File & E-Mail Assistant will update the recently opened file list for any file that you open from the Windows Explorer. Without the File & E-Mail Assistant, Excel only adds files to the recently opened list if you open them via File, Open. When you select File, File & E-Mail Assistant or click on the quick access button, the following dialog appears:

To use the E-Mail assistance features:

• Select the files you wish to e-mail in the File & E-Mail Assistant's dialog
• Click the Copy to Clipboard button. This copies the paths and file names of the selected files to the clipboard.
• Display your E-mail program's file attachment dialog
• Press Ctrl-V or right click in the file name dialog and select Paste
• When you press enter, the files are attached! Simple, easy, and a lot faster than searching through drives and folders and files!

If you have many files to e-mail, then you can copy just the path of a file to the clipboard and paste into your e-mail program's file attachment dialog. To do this, select a single file and click the second option button which indicates that you wish to copy just the file's path. Then when you press enter, the file's folder is displayed, making it easy to select files from that folder.

To use the File assistance features:

• Select the files you wish to open
• Clicking on the Open button and the files are opened

If you select just a single file, then you can either open it or go to its directory by clicking the Go To button. If the check box for using the Windows Explorer is clicked, then the Windows Explorer is opened to the selected file's directory. If it is not checked, then Excel's File Open dialog is displayed, with the current directory being the selected file's directory.

You can sort the list of files by clicking on the any of the three sort by buttons.  You can sort by last opened, by folder A to Z order or by folder by last opened order.

The Filter button allows you to display just the files containing specific text.  This allows you to reduce the visible files if you are searching for a particular file.  The Remove button allows you to remove files from the list that you no longer wish to be on the list.  The files are not deleted or erased.  If you open the files again, they are added back to the list.