That is what I did, I just typed it wrong above, when I try to compile it using Dim session as new notessession I get an error saying "Invalid use of New keyword". I'm using Excel, and I have the Lotus Notes Automation Classes reference installed.
forget what I said about the syntax. now I am having trouble at runtime. Set db = session.CURRENTDATABASE gives me error 91 "object variable or With block variable not set". Also when I tried to Dim Session As New Notes session I got an error saying it wasn't a valid use of the New keyword
Dim...
I am having trouble getting the code you gave me to work. I have Notes Version 5.0.11. I can get a Notes Session with different syntax.
Set session = CreateObject("Notes.NotesSession")
Set db = session.GETDATABASE("chssrvnotes2/McJunkin", "names.NSF")
so would that change the syntax on those...
here is a sample message, this is how the body will always be.
*** AUTOMATIC MESSAGE *** (DO NOT ANSWER OR REPLY TO THIS MESSAGE)
TRANSFER ORDER 7607953 ON PACKING SLIP 7607953001
PEGGED TO ORDER 7607950 LINE 000500001 FOR CUSTOMER 53105 0070
ALLOWED FREIGHT AMOUNT: 43.05...
that good is great, it will work perfectly. Now, how can I get that info I need from the body? The number I need will always be preceded by the same info. Something like
ACCOUNT#: 1548754
AMOUNT#: 15.84
DATE: 10/07/04
If I can get the line into a string variable, I can get it from there. I...
I don't know the exact content I will need from the emails, but it will be something like order#s, account#s, maybe dollar amounts. That type of thing. The boss hasn't sent me one of the messages yet, he just showed me one on his computer and asked me if I could do it, and I said I would try :)
Sure,
I can try to clarify a bit. What I was hoping to do with the messages is once the data is extracted either move them to a different folder or just delete them. That way the only messages in the folder are ones that need dealt with. Secondly, yes the info is in the message body, and...
Hi,
I am having trouble finding a solution on how to do this. I have auto generated messages that I put in a folder using a mail rule. I want to open those messages, extract some information and then move the message to another folder using vbscript. I need help with the commands I need to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.