Custom fields in public folders
I am trying to accomplish the following:
1) Faxes come in to a single public folder for customer service order processing. (already set up)
2) Would like to set up 3 custom fileds 1) Rep name 2) Order ID 3) formula for the public folder fields.
3) A CS rep goes in to the public folder (using custom fields) enters their name and the order reference number in public folder for that mail.
4) processes the order
4) a scheduled routine then grabs the order number and updates the formula field in the public folder with a formula based on a query to our order entry system (ship date) and the date the fax came in to public folders. (Thus providing an ordered-to-shipped
metric)
5) management runs a report on the customized fileds (crystal or srs)
So for a completed order the department should be able to look in the public folder and see history of the public folder record, the order number, the rep who processed it and the result of the formula (ship date - fax date essentially).
Is this possible with Outlook or Exchange public folder programming? We are running mixed 2003 and 2007 Oulook clients and Exchange 2007.
September 7th, 2010 9:41pm
I would ask this in the Dev Forum:
http://social.technet.microsoft.com/Forums/en-US/exchangesvrdevelopment/threads
Or Outlook Forums:
http://social.technet.microsoft.com/Forums/en/outlook/threads
Quite frankly, public folders are not designed for this, so I would rethink that. A mailbox would be better and even then , there is enough work involved here that it may make more sense to look at 3rd party products or look at handling this outside
of Exchange.
Free Windows Admin Tool Kit Click here and download it now
September 8th, 2010 2:59am