A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:---
a program is trying to automatically send email on your behalf
do you want to allow this?
if this is unexpected it may be virus and you should choose no
I dont want to show this message this mail should go without confirmation
becouse this hampers our security level. Please solve my problem.
i am sendeng you example of coding
PROCEDURE inmail IS
BEGIN
Declare
objOutlook OLE2.OBJ_TYPE;
objMail OLE2.OBJ_TYPE;
objArg OLE2.LIST_TYPE;
objAttach OLE2.OBJ_TYPE;
MSENT OUTWARD_CHALLAN_MASTER.SENTTO%TYPE;
MISS OUTWARD_CHALLAN_MASTER.ISSUEDBY%TYPE;
BEGIN
objOutlook := OLE2.CREATE_OBJ('Outlook.Application');
objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,0);
objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem',objarg);
OLE2.DESTROY_ARGLIST(objarg);
SELECT ISSUEDBY,SENTTO INTO MISS,MSENT FROM OUTWARD_CHALLAN_MASTER WHERE CHALLANNO=:OUTWARD_CHALLAN_MASTER.CHALLANNO;
OLE2.SET_PROPERTY(objmail,'To',xyz@company.com');
OLE2.SET_PROPERTY(objmail,'Subject','t : Outward Challan Generated ('||:OUTWARD_CHALLAN_MASTER.CHALLANNO||') ..');
OLE2.SET_PROPERTY(objmail,'Body','This is to inform that Fixed Asset has been sent with following details.
Outward Challan # = '||:OUTWARD_CHALLAN_MASTER.CHALLANNO||'
Sent to := '||MSENT||'
Issued By := '||MISS||'
Pls look into ... for detail.');
OLE2.INVOKE(objattach, 'Add', objarg);
OLE2.INVOKE(objmail,'Send');
END;
END;
Software/Hardware used:
Software/Hardware used:
ASKED:
April 13, 2009 9:06 AM
UPDATED:
May 12, 2011 12:12 PM
RELATED QUESTIONS
- Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?
- Send mail from my second mail-account in Lotus Notes
- How can I copy/paste a table from Excel to Lotus Notes
- Error : 505, local host gmail, not gatway (ASP)
- Fax Server is printing a blank page when using EmbedObject "embed_attachment "
Answer Wiki:
Hi you need to lower the security settings in Outlook in order to allow this.
---------
This is from <a href="http://support.microsoft.com/kb/263084">a Microsoft Support article</a>:
"<b>Cause</b>:
When you apply the Microsoft Outlook E-mail Security Update, the Outlook E-mail Security Update provides additional levels of protection against malicious e-mail messages. The Outlook E-mail Security Update changes the way that attachments are handled by Outlook <i>and the way that Outlook can be controlled programmatically</i>.
<b>Note</b> The Outlook E-mail Security Update is included with Microsoft Outlook 2002, Microsoft Office Outlook 2003, and Microsoft Office Outlook 2007.
Workaround:
To work around this problem, you can customize the behavior of the Outlook E-mail Security Update. <b>You can customize the behavior only if you are running Outlook in a Microsoft Exchange Server environment, and your e-mail messages are delivered to a server-based mailbox.</b>
<b>Note If your mail is delivered to a Personal Folders (.pst) file, you cannot configure the settings for the update.</b>"
On the other hand, are you using an Oracle Database ?
If so, you could send mails from the database, with the help of the utl_smtp package, so you don't need to use outlook at all for your automated e-mail messages.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
