Answered by:
Stop 'Pending Send' emails / Get rid of them

Question
-
Hi,
Is there a way to stop the 'Pending Send' emails in CRM 2013? We have plenty of emails that had failed to send but now we would like to cancel these emails and avoid sending them. Is there a supported or unsupported way of doing this?
We are using CRM for Outlook and not the email router.
Regards,
Gagandeep Singh
My CRM blog | My SharePoint blogMonday, November 17, 2014 3:35 AM
Answers
-
Gagandeep,
One supported method would be to build a workflow that uses an "Update Status" step to reset the status back to Active and then another "Update Status" step to set it to "Cancelled". You would then need to do an Advanced Find to get the list of Emails in Pending Send status and run the workflow for each one. There are some workflow automation tools out there that you could use so that you could run the workflow for more than 250 records at a time. Its not pretty, but should get the job done.
- Marked as answer by Gagandeep.Singh Wednesday, November 26, 2014 8:26 AM
Monday, November 17, 2014 6:17 AM -
HI Gagan,
Resolution 1:The Microsoft CRM creates system jobs for sending the pending emails with the end date of December-9999. If the user does not need the old pending mails to be sent then the user can delete these system jobs by following the steps given below:
- Go to “Advance Find”.
- Select the values as shown below:
3. Click on the “Results” to view the Pending Email messages.
4. Delete the emails that are not required to be sent.
5. Go to Settings à System Jobs.
6. Select the View as “Suspended System Jobs”.7. Review the jobs related to the Email.
8. Select and cancel the jobs for the emails that are not required to be sent.Regards, Saad
- Marked as answer by Gagandeep.Singh Wednesday, November 26, 2014 8:25 AM
Monday, November 17, 2014 7:20 AM -
Create a real time workflow that changes the status of the email entity to Cancelled if the current status is "Pending Send".
Use advanced find to locate all emails with a state of Pending Send and then run the above workflow.
You could automate the entire thing by creating a workflow as follows:
- Workflow on Email create
- Check email is outbound
- Make the workflow Wait, e.g. for 1 hour, to allow normal send operations to occur
- If the email is still in "pending send", then cancel the email
This way, the workflow will automatically clear up emails that can't be sent. You can also use the "No. of delivery attempts" field to control the logic too, e.g. only cancel after 3 delivery attempts.
- Proposed as answer by Caratacus Tuesday, November 18, 2014 10:03 AM
- Marked as answer by Gagandeep.Singh Wednesday, November 26, 2014 8:26 AM
Tuesday, November 18, 2014 10:03 AM
All replies
-
Gagandeep,
One supported method would be to build a workflow that uses an "Update Status" step to reset the status back to Active and then another "Update Status" step to set it to "Cancelled". You would then need to do an Advanced Find to get the list of Emails in Pending Send status and run the workflow for each one. There are some workflow automation tools out there that you could use so that you could run the workflow for more than 250 records at a time. Its not pretty, but should get the job done.
- Marked as answer by Gagandeep.Singh Wednesday, November 26, 2014 8:26 AM
Monday, November 17, 2014 6:17 AM -
Hi Gagan,
You can write a simple console/windows app which reads the emails with Pending Send Status and update them. You can use the following link for Status and Status Reason mapping.
http://msdn.microsoft.com/en-us/library/hh155312.aspx
Regards,
Gopinath.
Monday, November 17, 2014 6:38 AM -
HI Gagan,
Resolution 1:The Microsoft CRM creates system jobs for sending the pending emails with the end date of December-9999. If the user does not need the old pending mails to be sent then the user can delete these system jobs by following the steps given below:
- Go to “Advance Find”.
- Select the values as shown below:
3. Click on the “Results” to view the Pending Email messages.
4. Delete the emails that are not required to be sent.
5. Go to Settings à System Jobs.
6. Select the View as “Suspended System Jobs”.7. Review the jobs related to the Email.
8. Select and cancel the jobs for the emails that are not required to be sent.Regards, Saad
- Marked as answer by Gagandeep.Singh Wednesday, November 26, 2014 8:25 AM
Monday, November 17, 2014 7:20 AM -
Create a real time workflow that changes the status of the email entity to Cancelled if the current status is "Pending Send".
Use advanced find to locate all emails with a state of Pending Send and then run the above workflow.
You could automate the entire thing by creating a workflow as follows:
- Workflow on Email create
- Check email is outbound
- Make the workflow Wait, e.g. for 1 hour, to allow normal send operations to occur
- If the email is still in "pending send", then cancel the email
This way, the workflow will automatically clear up emails that can't be sent. You can also use the "No. of delivery attempts" field to control the logic too, e.g. only cancel after 3 delivery attempts.
- Proposed as answer by Caratacus Tuesday, November 18, 2014 10:03 AM
- Marked as answer by Gagandeep.Singh Wednesday, November 26, 2014 8:26 AM
Tuesday, November 18, 2014 10:03 AM