Hi,
How to read outlook mail subject and save in excel.
Hi,
How to read outlook mail subject and save in excel.
Corrected Solution : How to get outlook email subject into string variable - #4 by Topi
Reference : Lesson 11 practice 1 - #12 by hellitonwoo
Regards,
Dominic
How to save( All Mail subject) of outlook in excel
@neerajmca5, hope it has been answered here,
How to get outlook email subject into string variable - #6 by Topi
Regards,
Dominic
Hi @neerajmca5,
Use Get Outlook Mail Message activity to get the all the mails
Properties Top → “-1” to get all the mail messages.
if you want only unread mail messages check the OnlyUnReadMessages
create datatable using Build datatable ->Column as “Subject”
then using for each activity loop through the mail.
strSubject=item.Subject.Tostring
using add data row activity add the subject value.(strSubject)
after loop finish use Write range activity to write the Subject in the excel file.
For Reference
Regards,
Arivu
Hi @neerajmca5,
I have the same workflow as you have mentioned i got “From, Subject, Date” in a variable & i got the data(reflects in message box). After adding those 3 variable in Input ArrowRow of “Add Data row” activity & running the workflow i am facing the below mentioned exception.
Source: Add data row
Message: Object reference not set to an instance of an object. This error usually occurs when using a variable with no set value (not initialized).
Exception Type: NullReferenceException
Please share some light on the above scenario OR if you have similar workflow can you share it
Regards,
Suhas
Hi @Dominic
I am trying to store the subject name into excel, but its giving me error.
"string can not be converted into datatable"like that.
so I am unable to store it into excel can you pls help??
Hi @arivu96
I am trying to store the subject name into excel, but its giving me error.
"string can not be converted into datatable"like that.
so I am unable to store it into excel can you pls help??