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

Notifications

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) / Use external list to i...
Microsoft Dynamics CRM (Archived)

Use external list to identify contacts within CRM

(0) ShareShare
ReportReport
Posted on by Community Member

We have a need to contact a number of people from our CRM2011 database that have been identified outside of Dynamics and I am trying to work out the best way to pick out these specific contacts in order to put them into a Marketing List.

I have tried using the Advance Find, but only seem to have the option to ask for one match per line, and as there are at least 1000 records that is not really feasible.

Is there some way to import or upload this list to cross reference within CRM, or is there a way to select multiple entries in the Advance Find option (so I could in effect Paste the whole list of CustomerIDs into one line with some sort of separator).

Many Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    You can do one thing. add a new boolean field on contact. Keep the default value as no. export the contacts with that field. Copy those contacts to an excel file and keep the external list in another excel sheet. Apply vlookup to match. Update the boolean field to yes for those who matched. Now re-import contacts. now while adding the contacts to a marketing list you can filter by that boolean field = yes.

  • Community Member Profile Picture
    Community Member on at

    Many Thanks Vikas - I'm a bit of a newbie to Dynamics at the moment but I think I follow what you suggest :-)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans