Microsoft Dynamics CRM has been designed to capture all business data relevant to your business and customers; however sometimes it can be a challenge to find the data you are looking for once it is in the system if you aren’t familiar with using the Advanced Find feature.
As a relatively new user of CRM I’d like to share with you what I’ve recently learned about the power of Advanced Find.
I had a client call me this week wanting to know how to export a list of a Marketing List Members (with phone numbers and email addresses) to a static Excel worksheet. From the Manage Members tab in the Marketing List entity you can export a static worksheet but you are not able to specify the columns displayed. The export to dynamic worksheet option allows you to select the columns to display, however the results will only display in Excel when the user has access to your CRM server (not helpful in this situation). We came up with a very easy work around that my client will be able to recreate any time she needs to repeat this process. The answer? Advanced Find.
Advanced Find allows you to ‘Look For’ any entity in CRM, add search criteria and choose the information you want to find by using the Edit Columns button. In the scenario above we:
1. ‘Looked For’ Contacts
2. Selected Marketing Lists as the regarding entity
3. Added a Name Equals Marketing List Name search criteria
4. Used Edit Columns to specify the columns to display.
From the Advanced Find results page you have several options including Mail Merge, Create Quick Campaign, Run Workflow and of course, export to Excel.
This kind of Advanced Find query could be run on any CRM record type with a multitude of search criteria specified, providing you with a very concise list of information based on your specific need at the time.
This is just one example of how you can use Advanced Find to find data in CRM. In my blog next week I will step you through how to create and save custom Views in CRM using Advance Find.
