Home » Developer & Programmer » Forms » Microsoft Out Look (To get Mail Failure)
Microsoft Out Look (To get Mail Failure) [message #314642] Thu, 17 April 2008 06:08 Go to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
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 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

Can i read e-mail SUBJECT by some mean through form6i??
Re: Microsoft Out Look (To get Mail Failure) [message #314987 is a reply to message #314846] Fri, 18 April 2008 08:18 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
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.
Re: Microsoft Out Look (To get Mail Failure) [message #315557 is a reply to message #314987] Mon, 21 April 2008 21:18 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
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
Re: Microsoft Out Look (To get Mail Failure) [message #315686 is a reply to message #315557] Tue, 22 April 2008 07:17 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
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.
Re: Microsoft Out Look (To get Mail Failure) [message #316696 is a reply to message #315686] Sun, 27 April 2008 20:12 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
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
Re: Microsoft Out Look (To get Mail Failure) [message #318897 is a reply to message #316696] Thu, 08 May 2008 07:12 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
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??
Re: Microsoft Out Look (To get Mail Failure) [message #319082 is a reply to message #318897] Fri, 09 May 2008 00:23 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
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
Re: Microsoft Out Look (To get Mail Failure) [message #319548 is a reply to message #319082] Mon, 12 May 2008 02:43 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
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.
Re: Microsoft Out Look (To get Mail Failure) [message #319572 is a reply to message #319082] Mon, 12 May 2008 04:51 Go to previous message
musman
Messages: 147
Registered: July 2007
Location: Lahore
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:
  


Current Time: Sat Feb 08 13:58:40 CST 2025