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

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Way to identify contacts using excel list of emails as a Look up

(0) ShareShare
ReportReport
Posted on by 30

Hi, 

I am trying to identify a group of contacts to email.  Currently I do not have the field in Dynamics I need to identify and build a segment.  However I do have an excel list of email addresses for these contacts.  Is there anything I can do to use this list as a look up?  There are far to many on this list to use Advance find and add manually to a segment.  Many thanks

I have the same question (0)
  • Verified answer
    cloflyMao Profile Picture
    25,210 on at
    RE: Way to identify contacts using excel list of emails as a Look up

    Hi ECross,

    You can create a custom entity to save contacts in excel list.

    After the custom entity has been created, download its import template:

    Advanced settings > Settings > Data Management > Templates for Data Import

    pastedimage1589337618156v1.png

    pastedimage1589337692027v2.png

    pastedimage1589337937259v3.png

    Copy data by column from your excel file to template:

    pastedimage1589338012505v5.png

    Import data from the template into Dynamics database:

    we could import it in marketing application:

    pastedimage1589338151781v6.png 

    or still in Data Managment page:

    pastedimage1589338211843v7.png

    Whatever way we take, the status of import job could be found in Data Management > Imports

    pastedimage1589338400462v8.png

    The imported contact records:

    pastedimage1589338452223v9.png

    Create a lookup field for Contact entity, the entity of the field is our custom entity.

    pastedimage1589338546731v10.png

    Add the field to any one of form of Contact entity, save and publish change

    pastedimage1589338725199v11.png

    All imported records are available to select:

    pastedimage1589338867494v12.png 

    Regards,

    Clofly

  • ECross Profile Picture
    30 on at
    RE: Way to identify contacts using excel list of emails as a Look up

    Hi Clofly, thanks so much for helping and giving so much detail.  We will try this today and let you know how we get on.  Have a top day

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 179

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 127 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans