Bulk Delete email attachments.

(0) Share

Report

Posted on by Dan Oldenkamp

So I can use the advanced find to find thousands of emails with large file attachments, but there appears to be no way to bulk delete just those attachments without deleting the emails themselves.

Is this correct?

Anyone know of a way to set the default so that email attachments will not be stored in CRM?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Muhammad Adeel Javaid 5,580 on at

Like (0)

Report

Follow the links mentioned below please:

mscrmtools.blogspot.com/.../new-tool-bulk-delete-launcher.html

social.microsoft.com/.../fe1ec159-f079-43e7-9f13-dc55f13751d4

Was this reply helpful? Yes No
Suggested answer

Aaina Gupta on at

Like (0)

Report

The emails would need to be reset to draft status first before you can delete the attachments and that can be done through a workflow or via the SDK. Setting the emails back to draft status would allow for a bulk deletion of email attachments.

Was this reply helpful? Yes No
AFTAB HUSSAIN on at

Like (0)

Report

Hi Dan,

Please refer to the link below for more information.

community.dynamics.com/.../216624.aspx

Thank You !

Was this reply helpful? Yes No
Frank Lee 4,617 on at

Like (0)

Report

Reference this doc:

community.dynamics.com/.../deleting-email-attachments-in-dynamics-crm-2016

Was this reply helpful? Yes No
Franglais on at

Like (0)

Report

Looks like this no longer works sin D365 (well, at least in my instance it doesn't!)

Anyone got an updated version of this tool?

Was this reply helpful? Yes No
Suggested answer

ShahXu 1,515 on at

Like (1)

Report

just use this code and you have no need to delete emails, it will delete all the attachments greater than mentioned size in below code

IOrganizationService Service = GetCrmService();

QueryExpression queryAtt = new QueryExpression("activitymimeattachment");

queryAtt.ColumnSet = new ColumnSet(new string[] { "activityid", "attachmentid","filesize" });

queryAtt.Criteria.AddCondition(new ConditionExpression("filesize", ConditionOperator.GreaterEqual, 100000));

EntityCollection eatt = Service.RetrieveMultiple(queryAtt);

foreach (Entity item in eatt.Entities)

{

Service.Delete(item.LogicalName,item.Id);

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hey Shahzeb, what is the size of attachments that are larger then for this script? ConditionOperator.GreaterEqual, 100000));

am i correct that this is greater then 100mb? Also will this script work in a crm 4.0 environment? Thanks!!!

Was this reply helpful? Yes No