OraFAQ Forum: Forms => Microsoft Out Look (To get Mail Failure)

Members

Help

Home

Home » Developer & Programmer » Forms » Microsoft Out Look (To get Mail Failure)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Microsoft Out Look (To get Mail Failure) [message #314642]

Thu, 17 April 2008 06:08

musman
Messages: 141
Registered: July 2007

Senior Member

i have been able to send mail through form using outlook.
Now requirement is that in case of mail failure delivery.
e.g
like if mails fails to deliver then failure message will be received in outlook.

So in case of failure i have to get that message from outlook and store in some table in database..Forms 6i i am using..

Any idea how to do this..
or any other better suggestion to intimate client when mail delivery is failed.

[Updated on: Thu, 17 April 2008 06:41]

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #314846 is a reply to message #314642 ]

Fri, 18 April 2008 00:43

musman
Messages: 141
Registered: July 2007

Senior Member

Can i read e-mail SUBJECT by some mean through form6i??

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #314987 is a reply to message #314846 ]

Fri, 18 April 2008 08:18

musman
Messages: 141
Registered: July 2007

Senior Member

or may be i have to ask it like.
i need to search the inbox for mails with a certain string
within their title.

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #315557 is a reply to message #314987 ]

Mon, 21 April 2008 21:18

djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia

Senior Member

Have you been able to find the description of the Outlook API? If not then search the Micorsoft websites. This is more a Micorsoft question than a Forms question.

David

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #315686 is a reply to message #315557 ]

Tue, 22 April 2008 07:17

musman
Messages: 141
Registered: July 2007

Senior Member

well thanks at least for replying.

i am almost 50 % done with this issue.

can you any one tell me this..

like for example. for following vb statement.

Set oNs = oOutlook.GetNamespace("MAPI")

OLE2 is written like this.

	OLE2.ADD_ARG(v_args,'MAPI');
  v_oNS := OLE2.INVOKE_OBJ(v_oOutlook,'GetNamespace',v_args);
  OLE2.DESTROY_ARGLIST(v_args);

now for vb statement..

Debug.Print .Subject

am bit confused to write OLE2 statement..
I think this is Forms question.as i am working in OLE2.
Any help will be appreciated.

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #316696 is a reply to message #315686 ]

Sun, 27 April 2008 20:12

djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia

Senior Member

I suggest you have aread of page 13 of http://www.oracle.com/technology/products/reports/10gr2/Reports_guide_to_changed_functionality.pdf and consider using a non-ole2 solution to your mail handling.

Do you HAVE to use Outlook? Could you instead set up a small Oracle email handler and direct all email that you need to process to it and then use the 'utl_mail' or 'utl_tcp'?

Also have a look at page 13 of http://www.oracle.com/technology/products/forms/pdf/ClientSideOLE.pdf which using Jacob instead of ole2.

David

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #318897 is a reply to message #316696 ]

Thu, 08 May 2008 07:12

musman
Messages: 141
Registered: July 2007

Senior Member

ok.now i have been able to export failed mails in text files on client machines.
(wrote VBA utility for that.).
i.e
message1.txt
message2.txt
message3.txt

Now i am calling that .exe in pre-form using HOST command which exports mails.
now have to read multiple files with out user interaction.
Text_Io read single file at a time.

Any logic or idea??

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #319082 is a reply to message #318897 ]

Fri, 09 May 2008 00:23

djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia

Senior Member

I recommend not performing these actions in the 'pre-form' triffer but in the 'when-new-form-instance' trigger.

If you can read one file why can't you read mor ethan one file? Just keep opening files until the open fails.

You could do a 'host('dir > aaa.tmp')' command and then read the 'aaa.tmp' file to tell you which files are available.

David

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #319548 is a reply to message #319082 ]

Mon, 12 May 2008 02:43

musman
Messages: 141
Registered: July 2007

Senior Member

ok i am doing this in when_new_form_instance.

Quote:

Just keep opening files until the open fails.

i can open one file like.

filename:='C:\backoffice\failmail\message1.txt';

but there can be any number of files.
so how do i get them all in
when_new_form_instance.

Report message to a moderator

Re: Microsoft Out Look (To get Mail Failure) [message #319572 is a reply to message #319082 ]

Mon, 12 May 2008 04:51

musman
Messages: 141
Registered: July 2007

Senior Member

Thanks djmartin for your consideration and help.
I have successfully completed my task.
Thanks again.

[Updated on: Mon, 12 May 2008 04:52]

Report message to a moderator

Previous Topic:	Problem with Enter Query and Execute Query forms 6i
Next Topic:	problem with alert

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 24 15:12:04 CDT 2008

Total time taken to generate the page: 0.03224 seconds

.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.