Your issue is solved. Instead of single quotes something diff you were using.
Actually for testing purpose i have created one dummy Db of same fields and the it start working with the single quotes i mentioned.
Output in DB :-
The thing i told you was already correct in previous 6th post about the syntax like this ‘Recieved’ but you were using wrong Single quotes. And if you want to give the column name within the query you can give or else not also.
Below is the correct one.
@Pratik_Wavhal Thank you for the reply …see what is my problem statement is that I’m receiving thousands of mail every day on particular email id so my work is to read that mails and store such essential data into ms access database. Now I’m automating this task in RPA for that I have designed a workflow in which I’m fetching the subject of mail .
**For Example : ** Sender : xyz@gamil.com Subject : Buy,678,ABC/EF Body: Product Details
I have three variables : fundName,fundType,fundQuantity So subject will split into three index fundName=ABC/EF fundType=Buy fundQuantity=678
As per the above explanation, it will store that details into a database for that I have used Insert query.