Cleaning Up CRM 2011 E-mails

I needed to clean up our database a bit and devised a method to identify potential spam emails so I could flag them for deletion. Mind you, it still takes a review of the email subject lines but this is a great start.

I created an advanced find and saved it as a personal view to identify e-mails that are incoming, not sent by a CRM lead, contact or account with no regarding. Here’s what it looks like:


I can now use this advanced find as a basis to find different useless e-mails in the database, and flag them for deletion.  I can also use it to identify e-mails that need to be associated using ‘regarding’, such as e-mails that we’ve received from Microsoft  by checking to see if is contained in the sender of the e-mail:


Let me know if this helps you!

Steve Noe

About stephenvnoe

CRM & XRM solution architect and project lead. I provide CRM design, services, mentoring & support to all manner of front office solutions and CRM projects.
This entry was posted in CRM 2011, CRM 4.0, How to. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s