Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how to open email and pass in text from Oracle Forms 6i ?

Posted on 2004-04-15
2
Medium Priority
?
517 Views
Last Modified: 2013-12-12
Hi,

I'd like to place a button on my Form which when pressed opens Outlook and pastes some text from the Form into the email body.

Whats the best way to do this ?

Rgds

CC
0
Comment
Question by:comradec
2 Comments
 
LVL 6

Accepted Solution

by:
musdu earned 600 total points
ID: 10834952
Hi,

create a button on your form and copy-paste following code.

regards

--------------

DECLARE

  -- check path of your outlook.exe on your PC ! ! !
 
  vOutlookExe VARCHAR2(300) := 'C:\Program Files\Microsoft Office\Office10\OUTLOOK.EXE -c IPM.Note /m ';
  vTO VARCHAR2(100) := 'musdu@yahoo.com';
  vCC VARCHAR2(100) := 'someone@yahoo.com';
  vBCC VARCHAR2(100) := 'someoneelse@yahoo.com';
  vSubject VARCHAR2(300) := 'This is subject of my mail';
  vBody VARCHAR2(2000) := 'This is body of my mail. ';
 
BEGIN

  Host(
    vOutlookExe||
    '"mailto:'||vTO||
    '?cc='||vCC||                                                -- if you don't want a cc, comment this line
    '&bcc='||vBCC||                                          -- if you don't want a bcc, comment this line
    '&subject='||vSubject||                  -- if you don't want a subject, comment this line
    '&body='||vBody||                                    -- if you don't want a body, comment this line
    '"'
  );

END;
0
 

Author Comment

by:comradec
ID: 10840718
Thanks Musdu,

Thats exactly what I want.

Cheers

CC
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question