Home » Developer & Programmer » Forms » send mail through a form
send mail through a form [message #244773] Thu, 14 June 2007 01:39 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii All

I want to send a mail through a form

lets see this example
i had a message I am sending an mail
i want want to send it to a fixed person suppose its mail is
eriad@intlaromatics.com

i tried in this issue and this is my code tries
and i am sending a mail by microsoft outlook
this code is done in the when button pressed trigger of a button

DECLARE 
vMESSAGE VARCHAR2(100) := I am sending an mail';
vADDRESS2 VARCHAR2(100) := 'ERIAD@INTLAROMATICS.COM';
 
 OUT_FILE text_io.file_type;
 v_file_path VARCHAR2(100) := 'E:\mail_send.txt';


BEGIN
OUT_FILE:=text_io.fopen(v_file_path,'A');
text_io.put(OUT_FILE,vMESSAGE );
TEXT_IO.FCLOSE (OUT_FILE);

host('C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE E:\mail_send.txt',NO_SCREEN);

MESSAGE ('MAIL SEND');
MESSAGE ('MAIL SEND');
END;


this code is sending a file mail_send.txt containing the message of I am sending an mail
and i don't want that
1. i want to send the message in the body of the mail not as attactment
2. i want to specify the address and send to him directy
i want to put it fixed and send it autmatic
Re: send mail through a form [message #245037 is a reply to message #244773] Fri, 15 June 2007 01:07 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you searched this forum for 'mail'? Do you HAVE to use MS-Outlook? have you searched this forum for 'outlook'? Have you searched the 'Outlook' help for an explanation of how to define the 'message'?

David
Previous Topic: Web Util Error Message On Form.
Next Topic: Info About 10g forms and reports
Goto Forum:
  


Current Time: Sat Feb 08 23:38:08 CST 2025