read hotmail into excel

Most e-mail systems are not fully POP that is only the index is put on your PC the actual e-mail is on that e-mail systems Server, HotMail is one of these. And, depending on how you read the e-mail, that is which reader you use you may or may not have portions of that e-mail in your PC's temp file.

So, to make long and complicated story shorter, you need to open an e-mail first before you can do anything with it. In most cases you will also need to COPY your selection from that e-mail to the Clip-Board first before you can do anything with it in Excel.

thanks Joe,
I am navigating too hotmail with the browsercontrol
that's all good, sort off..
because it's kind off a problem that you can not really get a handle on the loading off the page, probably something to do with frames

So, Y need a lot off if..then..else statements

anyway, i figured out that you can save the document.body.innerText to a textFile and
from there I can get the data out that finds itself just below the heading "full display".

Now I just need to know how to extract that little piece off information
The actual information is located between the caracters @@ and @@
something with instr?? I don't know just yet

I will try to figure that one out, but if you have any other suggestions that will be more efficient in terms off coding, please


Regards,
Richard

read hotmail into excel/Extract Text

RichNL:

A UDF will do this.
CODE IN Module1:

Option Explicit
Function GetTxt(text1) As String
Dim Len1 As Long
With CreateObject("vbscript.regexp")
.Global = False
.Pattern = "(@@)+.*(@@)+"
If .test(text1) Then
GetTxt = .Execute(text1)(0)
Len1 = Len(GetTxt)
GetTxt = Left(GetTxt, Len1 - 2)
GetTxt = Right(GetTxt, Len1 - 4)
Else
GetTxt = ""
End If
End With
End Function

RESULT:<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]

Thanks Jack,

I can use this
It's something different from the Instr function

I also think, that the loading of every email takes some time

I saw something somewhere that is probably a lot more efficient and that is too send something too a website and retrieve the information with the xmlhttp object.
Ofcourse, then i would need a website thirst, but it is something too think about for later on.


Richard