You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FTP VBA Script

Question
14
Views
0
Comments
edited Sep 1, 2012 11:07PM in Reporting and Analytics (TBE)

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!