Need Help: Read Email Subject Values and Append Them to Excel

[nationpetty]

Hello everyone,

I'm new to RoboTask and would appreciate some guidance.

I would like to create a task with the following workflow:

Monitor a mailbox and detect new incoming emails.
Extract three values from the email subject line. The values are separated by semicolons (;).
Open an existing Excel file with a fixed filename.
Insert the extracted values into columns A, B, and C.
Add each new email's data to the next available row without overwriting existing records.
Mark the email as processed or move it to another folder after the data has been saved.

Could someone point me in the right direction or provide an example task?

Thank you in advance for your help!

[Oleg]

To monitor new emails and extract email subject use Email actions. I hope you able to do it.

How to split the subject and save to EXCEL document see my example below
Save the task text to a file and use the Task->Import menu to import the task into RoboTask.
Also you can simply copy task text and paste it into the task list.
Then you can see and edit the task in task editor

Code: Select all

;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
 
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|307868550
Comment=STRINGLIST
ContinueOnError=INTEGER|0
DisableOnError=INTEGER|0
DoNotStopWhenShutdown=INTEGER|0
ExternalName=STRING|"Task1616"
Hide=INTEGER|0
ID=INTEGER|185477315
LogOnAsUser=INTEGER|1
Name=STRING|"Write values to EXCEL document"
OnErrorTaskID=INTEGER|0
Priority=INTEGER|3
RestrictRESTAPIAccess=INTEGER|0
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
StepPause=INTEGER|0
ToLog=INTEGER|3
UnicodeFormat=INTEGER|1
WriteGeneralLog=INTEGER|0

[Actions]
Action1=FOLDER
Action10=FOLDER
Action11=FOLDER
Action12=FOLDER
Action13=FOLDER
Action14=FOLDER
Action15=FOLDER
Action16=FOLDER
Action17=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER

[Actions\Action1]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""_ExtractedSubject"" with value ""First Value;Second value;Hello World!!!"""
Params=FOLDER

[Actions\Action1\Params]
_rt_variables_produced=STRING|"_ExtractedSubject"
expand=STRING|"0"
linecount=STRING|"1"
varname=STRING|"_ExtractedSubject"
varvalue=STRING|"First Value;Second value;Hello World!!!"

[Actions\Action10]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"

[Actions\Action11]
ActionID=STRING|"A_ROBOTASK_LOG"
Enabled=INTEGER|-1
Name=STRING|"Log message (neutral) ""Free row {_num}"""
Params=FOLDER

[Actions\Action11\Params]
expression=STRING|"3"
message=STRING|"Free row {_num}"
mode=STRING|"0"
type=STRING|"3"

[Actions\Action12]
ActionID=STRING|"A_MISC_COMMENT"
Enabled=INTEGER|-1
Name=STRING|"//Write values to excel"
Params=FOLDER

[Actions\Action12\Params]
comment=STRING|"Write values to excel"

[Actions\Action13]
ActionID=STRING|"A_VARIABLES_DELIMITED"
Enabled=INTEGER|-1
Name=STRING|"Split Text"
Params=FOLDER

[Actions\Action13\Params]
_rt_variables_produced=STRING|"_ExtractedSubject"
colon=STRING|"0"
comma=STRING|"0"
other=STRING|"0"
quote=STRING|"2"
semocolon=STRING|"1"
space=STRING|"0"
spaceasone=STRING|"0"
string=STRING|"{_ExtractedSubject}"
tab=STRING|"0"
variable=STRING|"_ExtractedSubject"

[Actions\Action14]
ActionID=STRING|"A_EXCEL_SET"
Enabled=INTEGER|-1
Name=STRING|"Excel Set Cells"
Params=FOLDER

[Actions\Action14\Params]
cell00000000=STRING|"A{_num}"
cell00000001=STRING|"B{_num}"
cell00000002=STRING|"C{_num}"
count=STRING|"3"
setmode=STRING|"0"
var00000000=STRING|"{_ExtractedSubject(0)}"
var00000001=STRING|"{_ExtractedSubject(1)}"
var00000002=STRING|"{_ExtractedSubject(2)}"
worksheet=STRING|"1"

[Actions\Action15]
ActionID=STRING|"A_MISC_COMMENT"
Enabled=INTEGER|-1
Name=STRING|"//You need to save document"
Params=FOLDER

[Actions\Action15\Params]
comment=STRING|"You need to save document"

[Actions\Action16]
ActionID=STRING|"A_EXCEL_SAVEDOC"
Enabled=INTEGER|-1
Name=STRING|"Excel Save Document"

[Actions\Action17]
ActionID=STRING|"A_EXCEL_CLOSE"
Enabled=INTEGER|-1
Name=STRING|"Excel Close"

[Actions\Action2]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""_XLSFile"" with value ""C:\temp\Book1.xlsx"""
Params=FOLDER

[Actions\Action2\Params]
_rt_variables_produced=STRING|"_XLSFile"
expand=STRING|"0"
linecount=STRING|"1"
varname=STRING|"_XLSFile"
varvalue=STRING|"C:\temp\Book1.xlsx"

[Actions\Action3]
ActionID=STRING|"A_EXCEL_OPEN"
Enabled=INTEGER|-1
Name=STRING|"Excel Open Document"
Params=FOLDER

[Actions\Action3\Params]
filename=STRING|"{_XLSFile}"
hide=STRING|"0"
mode=STRING|"0"
tryconnect=STRING|"0"

[Actions\Action4]
ActionID=STRING|"A_MISC_COMMENT"
Enabled=INTEGER|-1
Name=STRING|"//Find free row"
Params=FOLDER

[Actions\Action4\Params]
comment=STRING|"Find free row"

[Actions\Action5]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""_num"" with value ""1"""
Params=FOLDER

[Actions\Action5\Params]
_rt_variables_produced=STRING|"_num"
expand=STRING|"0"
linecount=STRING|"1"
varname=STRING|"_num"
varvalue=STRING|"1"

[Actions\Action6]
ActionID=STRING|"A_EXCEL_GET"
Enabled=INTEGER|-1
Name=STRING|"Excel Get Cells"
Params=FOLDER

[Actions\Action6\Params]
_rt_variables_produced=STRING|"_cell"
cell00000000=STRING|"A{_num}"
count=STRING|"1"
var00000000=STRING|"_cell"
worksheet=STRING|"1"

[Actions\Action7]
ActionID=STRING|"A_LOOP_WHILE"
Enabled=INTEGER|-1
Name=STRING|"While loop"
Params=FOLDER

[Actions\Action7\Params]
case=STRING|"0"
connection=STRING|"0"
count=STRING|"1"
operator=STRING|"8"
type=STRING|"0"
value1=STRING|"{_cell}"

[Actions\Action8]
ActionID=STRING|"A_VARIABLES_INCREMENT"
Enabled=INTEGER|-1
Name=STRING|"Increment variable ""_num"""
Params=FOLDER

[Actions\Action8\Params]
incement=STRING|"1"
vaiable=STRING|"_num"

[Actions\Action9]
ActionID=STRING|"A_EXCEL_GET"
Enabled=INTEGER|-1
Name=STRING|"Excel Get Cells"
Params=FOLDER

[Actions\Action9\Params]
_rt_variables_produced=STRING|"_cell"
cell00000000=STRING|"A{_num}"
count=STRING|"1"
var00000000=STRING|"_cell"
worksheet=STRING|"1"