RE: Emailing from TOAD for Oracle v 10.6 or 11.0

You could create a variable (options -> variables) and use the variable as an attachment.  Maybe something like: c:\TEST_FILE_%DATEFILE%_%TIMEFILE%.txt.



From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Friday, January 04, 2013 12:54 PM
To: [email protected]
Subject: Re: [toad] Emailing from TOAD for Oracle v 10.6 or 11.0

Additional question not covered in HELP:

How to attach a file that will have a different file name every time (due to a date/time variable)?  In other words, it needs to attach the most current file, eg.  TEST_FILE_date_time.txt  where date_time will change every time.

That's where I'm stuck at this point. I did read the help previous to my original email, but could not find the answer to these questions.Guess I should have put that in my email, huh? :-)

________________________________
From: Donna Buskirk <[email protected]<mailto:[email protected]>>
To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>
Sent: Friday, January 4, 2013 11:44 AM
Subject: RE: [toad] Emailing from TOAD for Oracle v 10.6 or 11.0


Hi there,
This is from the online Help in Toad (Go to Help | Index | Actions | Email).
[cid:[email protected]]


From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]>
Sent: January 04, 2013 11:40 AM
To: TOAD yahoo groups
Subject: [toad] Emailing from TOAD for Oracle v 10.6 or 11.0



Hi,

We have never emailed anything out of TOAD and have no idea how to do it. We are attempting to create an scheduled automated app that will email text files (that include a variable in the file name). Initially, the files will be emailed to an internal party, however, in the future, we may want to email to an outside party. Our email is MS Outlook 2007.

Would somebody be kind enough to share directions on how to setup email capabilities in TOAD, please.

Thanks,
Sandi