Copy from Lotus note body in mail to excel cells.

HI. All.

I need an excel macro to get different data from lotus notes text body and paste it into excel cells. I've looked hard searching through the Internet but it seems as is everybody is only interested in sending e-mails but not getting text data. Hope someone can help out here.
So I guess this is a one of the hard ones.

I found below code but in my excel 2003 I never reach to be able to test it, it give me errors.
But maybe some of the experts here can use it or change it or maybe some know another code to use.


Thanks in advance.

Sincerely

Abjac

My found not working code.

Please Login or Register  to view this content.

I'd be interested in seeing any responses too this one myself.

Hi. John Yes lets see if there will be any answers I think this is a very complicated one. So lets hope some have the knowledge.

ABjac

HI Thanks to John W on Osgrid he provided this below code. It works and open all mail in the inbox and display it in note pad. I need it to be changed to only open the mail which is open and display it in excel.
So have a look

Thanks

Please Login or Register  to view this content.

Thanks to John_W on Osgrid this thread is solved. He delivered a brilliant code. I cant vote there but here I will give the solution 5 stars.
The final code is like this.

Please Login or Register  to view this content.

Playing around with your last post, this appears to get the data into the activecell.

Please Login or Register  to view this content.

Probably can specify a destination range as well.

HI. John yes in my last post here the start cell is displayed. So for me this is brilliant.

Sincerely

Abjac