I did something similar, where the users wanted one email to contain a list
of all of the tickets in their group that met certain conditions. I created
a small sub-form in which to push only the info necessary for the
notifications (via timed Escalation), then I use Filters to concatenate the
data and push the final output to the Email messages form. (This is a
custom HD application).
Rick
On Mon, Mar 17, 2008 at 9:14 AM, Julie Rockwood <[EMAIL PROTECTED]> wrote:
> ** Hi Roger,
>
> In case you don't have enough options yet, I too have done something
> similar. My escalation executes a notify action. The text field
> something like this:
> Schema: mySchema
> Server: $SERVER$
> User: myMailUser
> Key: myKey
> Action: Query
> Result Template: myResultTemplate
> Qualification: '('7' = "Unassigned" OR '7' = "Open" OR '7' =
> "Re-Opened" )
>
>
> At 08:50 AM 3/17/2008, you wrote:
>
> **
> I have done something similar,
>
> Form A
> When your condition is true – Push a record to Form B.
> (Creating only record a day)
>
> Pushing – Form Name, Case Number, Name, Location, Account, etc
>
>
> This is pushed to a temp field, which then is appended to the
> body of the email (Field)
> Controlling the format how you wish
>
> Once a night, an escalation runs and emails the record (with
> all the entries listed and formatted within the Body
>
> This is one approach I have used
>
> Doug
>
> ------------------------------
>
> *From:* Action Request System discussion list(ARSList)
> [mailto:[email protected]<[email protected]>]
> *On Behalf Of *Nall, Roger
> *Sent:* Monday, March 17, 2008 10:12 AM
> *To:* [email protected]
> *Subject:* Email Multiple Records
>
> I have a request to email multiple records once a day. Basically, I will
> be inactivating accounts and I need to send one email with a list of all
> affected accounts. The email will include name and location. I am wondering
> if anyone has ever done anything like this before.
>
> ARS 6.03 patch 16
> WIN2003
> SQL2K
>
> Thanks in advance for any suggestions.
>
> Regards,
>
> Roger A. Nall
> Manager, OSSNMS Remedy
> T-Mobile, USA
> Desk: 813-348-2556
> Cell: 973-652-6723
> FAX: 813-348-2565
> sf49fanv AIM IM
> RogerNall Yahoo IM
>
> 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. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the
> Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where
> the Answers Are" html___
>
> -------------------------------------------------------
> *Julie Rockwood
> Los Alamos National Laboratory
> IST-APPS3
> (505) 667-9846
>
> * __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
