i have below code which copy the email content to excel on finding the specific subject line.
but its not copying the content properly and duplicating the data.email subject line goes something like this Request ID XXXXXX: Call Lodged here XXXXXX is numeric number.

the mail body is below:

Dear Finacle Service Team,

Request ID XXXXXX is Lodged.
Requester: ADASD_user
Severity Level: 1
Request Status: With Support Team for Ownership
Problem Description : KJSD KLJASDHJSD JKSDJHASD KJSADJAS KFL;KDF OQWEOQWE
Product: ABCD
Customer: ABCD_FNSSN

this should be copied in Excel in specified columns. but the below code is not copying properly and sometimes misses the mails.
pic44.JPG

attached pic depicts how its duplicating the data
CODE:

Please Login or Register  to view this content.