Home » Developer & Programmer » Forms » Sending mail from form (split from Text Moving on the Form)
Sending mail from form (split from Text Moving on the Form) [message #403607] Sun, 17 May 2009 08:50 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Sorry Vamsi i will adhere to Forum laws in future..Klat can u tell me how to send mail on clicking the check box on form
Re: Sending mail from form (split from Text Moving on the Form) [message #403611 is a reply to message #403607] Sun, 17 May 2009 09:46 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
If your question is not relevant to your original post, please post create a new post.

Anyway "for sending mail", you have so many hits in Google.
One sample hit.


By
Vamsi
Re: Sending mail from form (split from Text Moving on the Form) [message #403770 is a reply to message #403611] Mon, 18 May 2009 09:57 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member


did you get your solution?

Emails after clicking on check box [message #403875 is a reply to message #403607] Tue, 19 May 2009 05:37 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Can anybody tell me how i can send emails from forms 6i after clicking on check box to which user the email needs to send and a text box for user enter any message if he wants to send.Please give me any sample form so that i can manipulate according to me.
Re: Sending mail from form (split from Text Moving on the Form) [message #403878 is a reply to message #403770] Tue, 19 May 2009 05:45 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks klat i got the solution for moving text but i need more help on sending mails for which i have added a new thread u can see.
Re: Sending mail from form (split from Text Moving on the Form) [message #403879 is a reply to message #403611] Tue, 19 May 2009 05:58 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
vamsi kasina wrote on Sun, 17 May 2009 20:16
Anyway "for sending mail", you have so many hits in Google.
One sample hit.


By
Vamsi
Have you looked at the links?
What did you find?

By
Vamsi
Re: Sending mail from form (split from Text Moving on the Form) [message #403917 is a reply to message #403879] Tue, 19 May 2009 09:26 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Dear vamsi first of all the hits given by you are talking about oracle8i and there is one article i tried but its sends email but without any attachment or subject how to incorporate these also...
Re: Sending mail from form (split from Text Moving on the Form) [message #403927 is a reply to message #403917] Tue, 19 May 2009 10:01 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member

Try this code..

PROCEDURE Send_Outlook_Mail ( 
p_recipient        IN varchar2, 
p_subject          IN varchar2, 
p_body             IN varchar2, 
p_attachment       IN varchar2 
				                   	)IS 
	happlication    OLEOBJ; 
	hmailitem       OLEOBJ; 
	hrecipients     OLEOBJ; 
	hrecipient      OLEOBJ; 
	hattachments    OLEOBJ; 
	hattachment     OLEOBJ; 

        vEmailAddStr    varchar2(32500) := 	p_recipient;
	vEmailAddr      varchar2(200);
	isComa          number (3):= 0;
 	
BEGIN 
	
	Loop
		isComa := instr(vEmailAddStr,',');
	  if isComa = 0 then
	  	isComa := instr(vEmailAddStr,';');
	    if isComa = 0 then
		    vEmailAddr := vEmailAddStr;
		    vEmailAddStr := null;
		  else
		    vEmailAddr := substr(vEmailAddStr,1,instr(vEmailAddStr,';')-1);
		    vEmailAddStr := substr(vEmailAddStr,instr(vEmailAddStr,';')+1);
		  end if;   	
	  else
	    vEmailAddr := substr(vEmailAddStr,1,instr(vEmailAddStr,',')-1);
	    vEmailAddStr := substr(vEmailAddStr,instr(vEmailAddStr,',')+1);
	  end if; 
	
		hApplication := CREATE_OLEOBJ('Outlook.Application',TRUE); 
	
		INIT_OLEARGS(1); 
		ADD_OLEARG(0); 
		hMailItem := CALL_OLE_OBJ(hApplication,GET_OLE_MEMBERID(hApplication,'CreateItem')); 
		SET_OLE(hMailItem,GET_OLE_MEMBERID(hMailItem,'Subject'),p_subject) ; 
		SET_OLE(hMailItem,GET_OLE_MEMBERID(hMailItem,'Body'),p_body); 
		hRecipients := GET_OLE_OBJ(hMailItem,GET_OLE_MEMBERID(hMailItem,'Recipients')); 
		INIT_OLEARGS(1); 
		ADD_OLEARG(vEmailAddr); 
		hRecipient := CALL_OLE_OBJ(hRecipients,GET_OLE_MEMBERID(hRecipients,'Add')); 
		SET_OLE(hRecipient, GET_OLE_MEMBERID(hRecipient,'Type'),1); 
		INIT_OLEARGS(0); 
		CALL_OLE( hMailItem,GET_OLE_MEMBERID(hMailItem,'Save')); 
		INIT_OLEARGS(0); 
		CALL_OLE(hMailItem, GET_OLE_MEMBERID(hMailItem,'Send')); 
	
	  if isComa = 0 then
	     exit;
	  end if;	 
	  
	end loop;
END; 


Re: Sending mail from form (split from Text Moving on the Form) [message #404722 is a reply to message #403927] Sat, 23 May 2009 01:07 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

can i use the above procedure for forms 6i , second can i use attachment.
Re: Sending mail from form (split from Text Moving on the Form) [message #406256 is a reply to message #404722] Wed, 03 June 2009 01:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Did you search this forum for 'mail' and 'email', and also 'attachment'? Did you see 'utl_smtp' and 'utl_mail'?

David
Re: Sending mail from form (split from Text Moving on the Form) [message #406260 is a reply to message #406256] Wed, 03 June 2009 01:19 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Yes david i have resolved the issue by using utl_mail facility.Thanks very much for your concern.
Previous Topic: Question about parameter list
Next Topic: Export data with format mask
Goto Forum:
  


Current Time: Fri Dec 09 23:09:07 CST 2016

Total time taken to generate the page: 0.15684 seconds