Hi Westconn1

Thanks for your reply

On below line item i am getting error:
HTML Code:
mynumber = Mid(thebody, InStr(1, thebody, "TOTAL AMT") + 9, _
InStr(InStr(1, thebody, "TOTAL AMT"), thebody, "VENDOR") - _
InStr(1, thebody, "TOTAL AMT") - 9)
ERROR MASSAGE AS BELOW

Run time error '5:
Invalid procedure call or argument


Hope this will help...
Thanks
---------------------------