Send email to distinct email

[Yerlasdutco]

Hi folks,

I have a excel c olumn with list of emails. Some of email can be repeated

How can I send mail only once, if email already sent to this email address ?

[momlo · Accepted solution]

Hi @Yerlasdutco 

It depends on your logic and goal.

One option is below, but it really depends on the context you are automating.

1. Use excel actions (or my favorite sql 😁) to retrieve email addresses to the list variable

2. Use list action to remove duplicates

2. Use for each loop to send emails

[Yerlasdutco]

@momlo 

What will be in loop, if distinct emails saved in List?