Resend email

[shaik23]

Hi all,

i am having requirement to resend emails for approvals using ui action 

i have a script i need suggestion 

resendThisApproval();

action.setRedirectURL(current.sysapproval)

function resendThisApproval() {

   var e = new GlideRecord("sys_email");

   e.addQuery("type", "sent");

   e.addQuery("target_table", current.getTableName());

   e.addQuery("instance", current.sys_id);

   e.orderByDesc("sys_created_on");

   e.setLimit(1);

   e.query();

   if (e.next()) {

      e.mailbox = "outbox";

      e.type = "send-ready";

      if (e.update()) {

         gs.addInfoMessage("Resent: " + e.subject);

      } else {

         gs.addErrorMessage("Could not resend: " + e.subject);

      }

   } else {

      gs.addErrorMessage("Approval email not found for " + current.approver.name + " / " + current.sysapproval.number);

   }

}

[Sandeep Rajput]

@shaik23 Instead of querying the sys_email table, can't you re-trigger the email using gs.eventQueue('event_name',current,'param1','param2'); ?

[shaik23]

@Sandeep Rajput  It is recommended method ?

[Sandeep Rajput]

Yes, after all events are used for triggering emails.

[piyushsain]

Hi @shaik23 

By looking at your script the code will just pull any email that is on the table, it can be another email which is not for approval. If the current table is approval table then it works but other than that you need to add more query to find correct email.

I will suggest you to create a new copy of the email as it will be logged in the system that the email is sent multiple times or you can use event queue to trigger another email