Importing from Email

[gransbpa]

Hi there,

I'm looking for a way to get orderinfo automatically from email without user intervention. Anyone knows how to do this?

Thanks.

 

[vbajock]

yes

 

[gransbpa]

Hi vbaJock,

That's something for a start
Now, my next question is: how do I do this?

 

[vbajock]

are you using exchange?

 

[smitan]

I took some statements out of my coding which will give you an idea what to use and what to look for in the HELP files:

Set objOutLook = CreateObject("Outlook.Application&quot
Set objNameSpace = objOutLook.GetNamespace("MAPI&quot
Set objRF = objNameSpace.folders.mailbox

objRF.items(index).body

The body gives you the whole text of the messagebody and you will be able to use instr or other statements to find specific text there.

If you have other questions after you have read all the available help, post them here.

Good Luck
Hans
BTW, there are many other threads dealing with the same subject.

 

[gransbpa]

Thanks Smitan, vbaJock. I'm sorry but I should have mentioned this before: I use Lotus Notes as a mail client. Would this make it more difficult you think?