Ah, I see what you mean.
Here's an idea. Assume Form A holds your inactivated accounts and Form B holds your notifications. Once a day have an escalation push to Form B and always create a record. Have on Form B a table field with a qualification that captures all of the relevant records in Form A. On Create of Form B have a filter call a filter guide to walk the table and build the email with the relevant information and then push that information to the AR System Email Messages form. If you don't need/want a record of the emails in Form B you could just have the escalation push to the same record and have the filter execute on Modify. Roger From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, March 17, 2008 11:27 AM To: [email protected] Subject: Re: Email Multiple Records ** Hey Roger, The problem is this. Let's say there are 20 records in Form A that need to be pushed to Form B. How do you know that all 20 records have been pushed? The only way would be to use some sort of counter to capture how many records in Form A meet your criteria and then push that to Form B. You would then a filter on Form B to push the data to the Messages table when the counter = 0. Unless I am really missing something I can't think of another way. Of course it is Monday all I want to do is do a little celebrating. 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 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Medsker Sent: Monday, March 17, 2008 11:17 AM To: [email protected] Subject: Re: Email Multiple Records Roger, I think what Fred intended was that after setting up the email in the staging form that the final action would be to push the completed email to the "AR System Email Messages" form. The email engine will automatically pick up the email from there and send it. No second escalation is necessary. Roger Medsker Remedy Consultant Bluestem Consulting Group, LLC [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, March 17, 2008 9:57 AM To: [email protected] Subject: Re: Email Multiple Records ** Fred, So I assume that you are using an Escalation to change and push the records to the Staging form. Then you use another Escalation to send the email. I guess the only question is how you know that you have completed the first Escalation run. The only thing I can think of is to have a very large delta between the two Escalation times. Thanks for the help. 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 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, March 17, 2008 10:46 AM To: [email protected] Subject: Re: Email Multiple Records I have done something similiar. What I do is to push into a single record on a staging form where I append the data to a field. At the end of the process I push from the staging form to the Messages. Fred _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, March 17, 2008 9: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 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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"
