Pull email addresses from email domains

Accepted Solutions (1)

Accepted Solutions (1)

floriancourgey

27-03-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

20190327-163959-screenshot-3.jpg

1. Query with Addtional data "domain":

20190327-164533-screenshot-8.jpg

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

20190327-164307-screenshot-5.jpg

3. Intersection on "domain"

1720225_pastedImage_7.png

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