Pull email addresses from email domains

Avatar

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
yash71029733
Level 2

27-03-2019

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Springboard
MVP
Florian_Courgey
MVP

Likes

93 likes

Total Posts

87 posts

Correct reply

19 solutions
Top badges earned
Springboard
Validate 1
Establish
Contributor
Ignite 1
View profile

Avatar
Springboard
MVP
Florian_Courgey
MVP

Likes

93 likes

Total Posts

87 posts

Correct reply

19 solutions
Top badges earned
Springboard
Validate 1
Establish
Contributor
Ignite 1
View profile
Florian_Courgey
MVP

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

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
yash71029733
Level 2

28-03-2019

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

Thanks again

Avatar

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Springboard
MVP
Venu_Reddy
MVP

Likes

163 likes

Total Posts

171 posts

Correct reply

53 solutions
Top badges earned
Springboard
Establish
Give Back 25
Give Back 10
Give Back 5
View profile
Venu_Reddy
MVP

27-03-2019

Hello,

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

Regards,

Venu

Avatar

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
yash71029733
Level 2

Likes

17 likes

Total Posts

26 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
yash71029733
Level 2

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