WS:Outlook Add-Ins
 WS:Addins Home
WS:Auto Accept
WS:Blank Reply
WS:Compress Out
WS:Fax Display Manager
WS:Peek Mail
WS:Repeat Appointment II
WS:Response Suite
WS:Reverse View
WS:License Packs
Contact Us | |
WS:Response Tracker and WS:Response Logger are members of Websetters family of Microsoft Office Add-Ins and make up the WS:Response Suite. These Addins extends the functionality of Microsoft Outlook 2000, 2002 and 2003. Description
With the increased importance of responding to customers and others in a timely and efficient manner it is increasingly common to install Customer Relationship Management (CRM) systems that help manage third party interaction and communications. If you run a small office or customer center and need to track the responsiveness of your email communications and can not justify a full functional CRM system, then WS:Response Suite may be for you. WS:Response Tracker and WS:Response Logger provide a cost effective solution that provides the ability to report on the time it takes to respond to emails. Extracts are generated as tab delimited files, enabling email response statistics to be imported into a variety of reporting tools such as Excel and Crystal Reports to produce mail response reporting by date, mail item and user. Features of the WS:Response Logger add-in:  | Automatically logs Original Mail Sent and Received details with the Reply Mail item for reporting by WS:Response Tracker | | No User Interface removing need for user training | | Installed on each system for which response reporting is required, replies should be stored in shared, public folder | | Integrates directly into Outlook | | Available as a FREE 28 day free pilot |
Features of the WS:Response Tracker add-in: | Extracts logged details from replies in shared mail folder and produces a tab delimited output file for importing into Excel, Crystal Reports or similar reporting tools | | Select Shared Mail Folder to perform extract against | | Select Start and End Date and Time period for extraction filter | | Specify whether Reply, Original Received or Original Sent dates are used as extract filter | | Reports on responding user/agent name, folder, mail item subject, sent and received date of the original email, date mail item replied, response time against original sent date (in hours) and response time against original received date (in hours) | | Installed on just those systems that need to create response reporting extracts | | Integrates directly into Outlook and accessed from the folder properties menu | | Available as a FREE 28 day free pilot |
The resulting extracted file from WS:Response Tracker is a tab delimited text file. To report on the extracted information, see the following details using Microsoft Excel. Creating Response Report using Microsoft Excel - Open Microsoft Excel and create a new worksheet
- Select the cell where you wish the report to begin
- Select the Data/Get External Data/Import Text File... menu option
- Select the file created by the Extract option in WS:Response Tracker
- You will then be presented with the Text Import Wizard
- You may step through the three steps of the wizard, or just select Finish as step 1
- Confirm the worksheet/cell location to place the imported data
- The data will then be displayed
The extracted data contains the following: The extracted data contains the following:
Row 1: Records Extracted from Folder <<Folder Name>>
Row 2: Extracted by <<Date base>>
Row 3: Start Date <<Selected Start Date/Time>>
Row 4: End Date <<Selected End Date/Time>>
Row 5: Column Titles
Row 6-n: Column Data Col 1: Agent <<Name of Replier>>
Col 2: From Folder <<Processed Folder>>
Col 3: Subject <<Subject title of mail item>>
Col 4: Date Replied <<Date of mail item reply>>
Col 5: Original Sent <<Date of original mail item sent>>
Col 6: Original Received <<Date of original mail item received>>
Col 7: Response by Sent Date <<Time taken to respond from Sent Date/Time>>
Col 8: Response by Received Date <<Time taken to respond from Received Date/Time>> Columns 7 and 8 are calculated in hours. 1 hour 30 mins will be represented as 1.5 hours. This aids the display of data in a graphical form if required. Users who purchase WS:Response Suite will receive a Excel macro to format the extracted data into a presentable form. These macros are being extended based upon user needs. Please contact us at support@websetters.co.uk for more details if you have any questions Register and Download today and reduce the number of entries in you contacts address list when sending emails and remove the confusion of sending to a contacts fax address in error.
| Name: | WS:Response Tracker | | Version: | 1.01 | | Outlook Support: | Versions 2000, 2002, 2003 | | Price: | $21.50 (USD) | | Product ID*: | WS:1107 | | File Size: | 1.64MB**(both addin installs downloaded) |
| Name: | WS:Response Logger | | Version: | 1.00.0000 | | Outlook Support: | Version 2000, 2002, 2003 | | Price: | $8.50 (USD) | | Product ID*: | WS:1106 | | File Size: | 112KB**(both addin installs downloaded) |
*You may also order this product by telephone. Follow the instructions from the purchase page and ensure that you quote the Product Name and Product ID when placing the order.
** WS:Response Tracker and WS:Response Logger may require additional Microsoft files if they are not already installed on your machine. If these are not found during the installation, they can be downloaded from WS:Common here. If needed, download and install in the same manner as the WS:Response Suite. If you have a requirement to extend Microsoft Word, Excel or Outlook with additional functionality then please contact software@websetters.co.uk with details of your requirements. |
