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] On Behalf Of Nall, Roger
Sent: Monday, March 17, 2008 10:12 AM
To: arslist@ARSLIST.ORG
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___
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
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
