Solved

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

Posted on 2004-04-15
2
506 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
musdu earned 150 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
grant privilege to execute a procedure for user in another database 20 51
Password_rules_securitty.. 12 46
Excess Redo 3 49
Oracle programming for starter 14 75
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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 shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

734 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