pramoddsrb
New Member
- Joined
- Jul 11, 2016
- Messages
- 1
Hi,
I've seen multiple fourms and found ways to copy the whole table or export the whole table. But my requirement is different. I have a mail like this:
Start Date: July-07-2016
Timings between
2016-07-04T07:59:00.000-05:00
and
2016-07-05T07:59:00.000-05:00
Name Accept Approved
John Yes No
Peter No No
Now from the above mail, I need to extract the Date and Timings. I am able to get the date using Find function in Macro and then fetching the Next 13 Characters.
But I'm having trouble on fetching the table data. I don't need the whole table, I want the entries under Accept , Approved individually so that I need to copy them and paste them in an excel sheet individually.
Can anyone help me on how to pick the selected table's data something similar to excel like cells(1,3)?
I've seen multiple fourms and found ways to copy the whole table or export the whole table. But my requirement is different. I have a mail like this:
Start Date: July-07-2016
Timings between
2016-07-04T07:59:00.000-05:00
and
2016-07-05T07:59:00.000-05:00
Name Accept Approved
John Yes No
Peter No No
Now from the above mail, I need to extract the Date and Timings. I am able to get the date using Find function in Macro and then fetching the Next 13 Characters.
But I'm having trouble on fetching the table data. I don't need the whole table, I want the entries under Accept , Approved individually so that I need to copy them and paste them in an excel sheet individually.
Can anyone help me on how to pick the selected table's data something similar to excel like cells(1,3)?
