I am trying to fetch the part of the Email body from outlook to Excel file using the following coding. It is giving me error as “Run time error '9' Subscript out of range “ as specified in the coding below. Would someone please review my code below and help me out. Thank you
My Code:
Please Login or Register to view this content.
On which line did you get the error?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Where are you running this code?
If posting code please use code tags, see here.
In the code i have mentioned where the error shows up. Thank you for the reviewing it
As macro in the outlook i am running this code
The error could be because vitem isn't actually an array.
You can check that in the Locals Window (View>Local Windows) when you get the error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks