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: