web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / NCOA & other data ...
Microsoft Dynamics CRM (Archived)

NCOA & other data hygiene

(0) ShareShare
ReportReport
Posted on by A-Z 30

We're a direct mail firm with a client that I believe is using Microsoft CRM Online.  Their database is currently around 75,000 records from various sources over many years.  They've asked us to clean up their data for direct mail purposes.

Is there an easy way to export and import address tables so that we can run address change and other mail data services?  What is the easiest way import appended data fields (e.g. demographics, URL's, etc.)?  Lastly, while we can easily identify duplicate records from address tables, is there a straightforward way to then merge the histories of the dupes into one record?

We wouldn't be doing the hands-on with CRM.  I'd be passing on the process requests to the client.  I just need to know what is possible so that we can develop the best data hygiene strategy.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at

    you can use different approach's for each task

    you can start with exporting to excel for updating:

    This will export to excel and than you can use Excell features like V-lookup to clean the data

    to eliminate duplicates, you can write code

    https://msdn.microsoft.com/en-us/library/jj863613.aspx

    or you can use this feature

    http://www.microsoft.com/en-us/dynamics/crm-customer-center/run-bulk-system-jobs-to-detect-duplicate-records.aspx

    however that is for removing duplicates.

    Merge feature in Dynamics CRM is available for Leads, Account, Contact and (if CRM 2013+ or online) Calls Entities

    http://crmbook.powerobjects.com/basics/data-management-in-microsoft-dynamics-crm/keeping-data-clean-in-microsoft-dynamics-crm/

  • Suggested answer
    CU30042133-0 Profile Picture
    CU30042133-0 2 on at

    Cut Through the Marketing Mayhem. Ignite Growth with Precision Targeting.

    Stuck in a sea of generic ads? We feel you. At M1 Data & Analytics, we're laser-focused on providing the rocket fuel you need to launch hyper-targeted marketing campaigns.

    How We Take Your Marketing to Hyperdrive:


    • Target Like a Jedi Master: We source and clean top-notch data from diverse galaxies, ensuring you reach your perfect audience, every single time.

    • Privacy Protectors: Relax, knowing we prioritize compliance with data privacy regulations. Your brand reputation is in our lightsaber-wielding hands.

    • Marketing on Autopilot:

      • Pinpoint Targeting: Beam in on your ideal customers with unmatched accuracy.

      • Hyper-Focused Segments: Craft customer segments so precise, they practically shout "Convert Me!"

      • Data-Driven Campaigns: Develop campaigns that resonate deeply and drive explosive results.


        •  


      •  

    Ready to unleash the power of data-driven marketing?

    Contact M1 Data & Analytics today and watch your campaigns go supernova!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
AS-17030037-0 Profile Picture

AS-17030037-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans