Retrieving Mail Id's from Group Mail Id

Help Studio
, ,
1

I have a requirement to Retrieve the list of Mail ID’s from Unknown group Mailid’s.

Any help would be greatly appreciated…

@ppr @Yoichi @Palaniyappan @Anil_G @supermanPunch

1 Like
2

Hello @vinitha_yachamaneni
Could you please be more specific? Can you please provide some sample inputs and Expected Outputs?
From my understanding, you need to filter the Specific emails from the Group of emails list.
It can be possible by filtering using For each loop of the Group mail list RequiredMaillist.Contains(EachmailGrouplist)

3

No @Gokul_Jayakumar

I have an Excel File which contains list of Individual Mailid’s and also Group Mail id’s (in this again we have individual mail id’s)

So, my requirement is if i have 3 individual mail id’s inside the group mail i want the count of that individual mailid’s inside from the group mail id

4

@vinitha_yachamaneni , Could you please provide me with a sample input for both individual and Group mail IDs? Also, share the Expected Output for the provided Input. It helps us to provide you with a better solution.

5

@vinitha_yachamaneni
Kindly Refer to this Xaml file you may get some Ideas.
Forum_Mail_IDSeperation.zip (59.8 KB)

6

@Gokul_Jayakumar Thank you Gokul I’ll go through it

7

image

@Gokul_Jayakumar This is my sample input. I need to read this exel and send mail to all this Id’s but using SMTP activity i can send to only limited no of people (ex:500 id’s).

So, I need a logic to meet this requirement. Here in this we don’t know which is group mail id n which is not and also we don’t know in that group mail id’s how many individual id’s are present.
but we need to send mail to all the id’s which are present in the excel.

8

@vinitha_yachamaneni ,
Is there any keyword for group mail that mentions or differs from the individual mail ID?
If yes, we can separate the Group mail mail ID based on that Keyword. In the above screenshot, you mentioned, “GroupoMail” as the key Word.

9

No we didn’t have any such keywords for the grp mails…

10

Do you need to send Seperate mail for each mail ID? Or can send a mail to 10 or 20 mail ID?

11

@vinitha_yachamaneni
Refer to this Xaml file, you may get some idea.
Here are 2 methods, one is send a separate mail to each one, another one sent a mail message to N number of ID.
Forum_Mail_IDSeperation.zip (75.0 KB)

12

Hi @vinitha_yachamaneni

You can also use Active Directory packages and easily figure out the users in a group mail ID. I have done it as an example for you and attached it. Please let me know if you need any further help.
Main.xaml (13.6 KB)

Thanks,
Shabbir

13

Hi @Mohammed_Shabbir

Will it work for Gmail ?

14

Active Directory works for google accounts. Give it a try, else we can connect to check on the same.

15

@Mohammed_Shabbir Ok will try and let you know