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:
Bookmarks