RE: Emailing from TOAD for Oracle v 10.6 or 11.0

Sandi,
Another option would be to put all the files in one directory like:

c:\Temp\THC_MEMBERS_01042013_1115.txt
c:\Temp\THC_MEMBERS_01042013_1120.txt
c:\Temp\THC_MEMBERS_01042013_1125.txt

And then, use the 'Folder Iterator' to loop thru them and send them one at a time.  Here's how you would do that if it helps.

1)  Do all your Export Datasets first (as we described yesterday).
2)  Add a 'Folder Iterator' to your app next
                                - Folder:  c:\Temp
                                - File Types:  *.txt
3)  Put the Email Action under the Folder Iterator action
                                - Attachments:  Add the Variable 'Folder Iterator 1' (use Add Var button and select 'Use Parent Output Variable')

When you run the App, it will…
                a)  Create all your export files
                b)  Loop thru all .txt files in the C:\Temp directory and send them in an email as an attachment one at a time.

Here's what it would look like:

[cid:[email protected]]


You could always add more File Control actions to move/delete the files after your done with them as well.

Hope this helps.

Dennis


From: [email protected] [mailto:[email protected]] On Behalf Of Gregory Liss
Sent: Friday, January 04, 2013 1:24 PM
To: [email protected]
Subject: RE: [toad] 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