Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

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

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

  • ECross Profile Picture
    ECross 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

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,198 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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans