There are a few ways to do, but there is a hidden field that has the mailbox ID (GUID). Doug
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E Jr. CTR USAF AFRL/SNOD Sent: Wednesday, March 21, 2007 2:47 PM To: [email protected] Subject: AR System Email Messages Importance: High I have a need to set up an escalation, etc that runs against AR System Email Messages. When it finds new messages in this form (as placed there by the remedy email engine), I would like to run a set fields to push the data to a new form. My problem is that I want to look at Mailbox Name to secure messages that come in from a specific remedy mailbox setup. I get an error that I can't since the mailbox name field is display only. Ah ha! So I'll instead use the to field, and grab only messages that were sent to the inbox in question. Now I get "Failure during SQL operation to the database" - evidently there is a further issue. "The data types text and varchar are incompatible in the equal to operator. (SQL Server 402)" My question is, once I have the email in remedy, procedurally, what is a good way to find it and process it? Someone has to have done this - please help me. Thanks! --- Michael Cupp, Jr., Contractor, RCF Oracle Database Administrator AFRL EBS Helpdesk Team Lead AFRL/SNOD Enterprise Operations Center Wright-Patterson AFB, Ohio DSN 785-3827 __20060125_______________________This posting was submitted with HTML in it___ DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
