Hi all of u i am facing this issue

Help Studio
1

“Venky Mama” thogativenkatesh12@gmail.com this is the output. i am using assign activity:value:item.from.tostring. but i need to "venky mama"saparated coloum and “thoagativenkatesh@12” saparated coloum in excel.give me suggition or sample work flow i hope u

2

Hi @Venky_Mama

To get only Name use the below syntax to get Venky Mama

currentMailMessage.From.DisplayName

To get the Mail ID use the below syntax to get thogativenkatesh12@gmail.com

currentMailMessage.From.Address

Add this in Add Data Row according to your column positions.

Regards

3

@Venky_Mama,

You should be using item.From.DisplayName to get “Venky Mama” and item.From.Address for thogativenkatesh12@gmail.com

You can get them in 2 variables and write them to Excel using Write Cell or write range.

Thanks,
Ashok :slight_smile:

4

sir how to give if condition in mail subject. i am using only get imap

5

@Venky_Mama,

There is no filter option while retrieving the emails from server. Only after retrieving the emails you can add logic like below.

  1. Use For each email activity
  2. Inside For Each use If activity to check subject like
    currentItem.Subject.Contains("Hi")

Thanks,
Ashok :slight_smile:

6

for each email not working sir its working only get out look mail activity

7

@Venky_Mama,

Try for each and give Argument type as MailMessage

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.