Skip to main content
YashP1
Level 2
March 27, 2019
Solved

Pull email addresses from email domains

I have a list of email domains(as many as 5000) and I need to pull the matching email addresses for all the email domains. Please advise.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Florian_CourgeyAccepted solution
    Level 4
    March 27, 2019

    Hi,

    You can convert your excel file to a CSV, and then do an intersection:

    Workflow with:

    1. a query on recipients with email domain (@domain is not empty) -> Add data, column @domain, Alias domain

    2. a data loading of the CSV, 1 column, internal name domain

    3. intersection on "A selection of column": domain

    1. Query with Addtional data "domain":

    2. Data loading details with 1 column "domain":

    3. Intersection on "domain"

    The result will contain only recipients with email domains equal to gmail.com or outlook.com

    In my example, I have 314 recipients with one of those 2 domains, among my initial 592

    Kind regards

    View in thread

    4 replies

    Venu_Reddy
    Venu_Reddy
    Level 6
    March 27, 2019

    Hello,

    You can use the function GetEmailDomain() from the list of functions and you will filter it.

    Regards,

    Venu

    Translate
      YashP1Author
      Level 2
      March 27, 2019

      Hi Venu, actually we have the email domain values in an excel file and need to pull the email addresses that has the corresposnding domain value from our database. Thanks

      Translate
      Florian_CourgeyAccepted solution
      Level 4
      March 27, 2019

      Hi,

      You can convert your excel file to a CSV, and then do an intersection:

      Workflow with:

      1. a query on recipients with email domain (@domain is not empty) -> Add data, column @domain, Alias domain

      2. a data loading of the CSV, 1 column, internal name domain

      3. intersection on "A selection of column": domain

      1. Query with Addtional data "domain":

      2. Data loading details with 1 column "domain":

      3. Intersection on "domain"

      The result will contain only recipients with email domains equal to gmail.com or outlook.com

      In my example, I have 314 recipients with one of those 2 domains, among my initial 592

      Kind regards

      Translate
        YashP1Author
        Level 2
        March 28, 2019

        floriancourgey​, thanks so much for your super clear instructions. This worked!

        Thanks again

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...