Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Pull email addresses from email domains

yash71029733
Level 3
Level 3

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.

1 Accepted Solution
Florian_Courgey
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

4 Replies
Venu_Reddy
Community Advisor
Community Advisor

Hello,

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

Regards,

Venu

yash71029733
Level 3
Level 3

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

Florian_Courgey
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

yash71029733
Level 3
Level 3

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

Thanks again