Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
FTP VBA Script
Content
With the recent accouncement that Insight will no longer support automatically FTP'ing scheduled reports, I've posted a technique here that will take scheduled reports that are sent via email and FTP the email attachment to an FTP server.
This example uses Outlook and VBA, but the technique will generally work with any email/operating system/scripting language.
The technique involves setting up an Outlook rule to run a VBA script when an email is received. The script will save the attachment (i.e. the emailed report) and FTP the file to an FTP server.
Attached are the files you'll need. Setup is as follows:
0