I wan to extract subject and add a new column to the excel , i Have extract the data from body and append to the final excel, how do i extract the email subject for each email body extracted?
while you using for each mail loop activity.
you can get mail.subject in assign activity ( you can create string variable)
assign: mymailsubject=mail.subject
Hope it helps!!!
yes you are right. you can use assign activity before save outlook mail message also.
if you want to use more number of mails you can use list of string
first you can create list of string as first activity.
assign: List_Ofmailsubject=new list(of string)
inside the for each activity you can use append item to list.
then how do i add the email subject into a new column base on my initial workflow screenshot i provided ?
1.okay better you can ignore about the list method, you can create build data table activity with one column ( mail subject)
2. then you can use add data row activity to add the list of emails
3. finally you can use add data column activity based on this you can add new column to your exist data table.
4. after adding you can set ordinal which help to add new column in certain position.
yourdatatable.Columns(yourcolumnname).SetOrdinal(0)
please refer the below sequence for reference.
Sequence4.xaml (9.7 KB)
Hope it helps!!!
it sound confusing , do u have an example ? or can u show me how it look like in my workflow ? Appreciate it alot
VDM.xaml (27.2 KB)
i have modified your code , on changing the scope of the variable (SPAN) and added my condition for list of emails in excel.
VDM.xaml (29.8 KB)
please re run and let me know you are problem resolved or not.
i try running the it but it has error at the activities of “Get full text”, just to clarify for this particular do i select the text i want to extract from the email subject or is something else that i need to extract ? sorry if i am question too many question , i am quite new to UiPath
you are using get text activity to scrap the email subject right? that one already i am getting from the above sequences you don’t need to scrap that again.
so what am extracting for the “Get full text activity”?
if the text i wan to extract change every time the browser open what should i change ?
i have an error at the “get full text activity” how can i resolved it ? sry i need to solved asap
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.