Auto download of Excel files in emails
 

Hi - sorry for posting in this group as sure this is not quite the
right group but only related. However I cannot find a better group and
have always had helpful replies in this group.

I have an Excel reporter that gets it's raw data from another
application in the form of another Excel file. My reporter imports the
data and presents charts etc.

At the moment users have provide the raw data Excel file but this is
haphazard and unreliable due to the fact that humans are lazy and take
holidays!

The application that produces the raw data Excel file can now be
configured to send the raw data Excel file via email but for full
automation I need this file on the network and not in an email inbox.

My company uses MS Exchange Server (not sure what version) so my
question is this: Is it possible to set up MS Exchange Server to
monitor an email account and when emails arrive automatically download
any attachments to a network location?

Thanks in advance for any pointers or help,
Chrisso

Auto download of Excel files in emails
 

On 11/06/2012 7:31 PM, Chrisso wrote:
Hi - sorry for posting in this group as sure this is not quite the
right group but only related. However I cannot find a better group and
have always had helpful replies in this group.

I have an Excel reporter that gets it's raw data from another
application in the form of another Excel file. My reporter imports the
data and presents charts etc.

At the moment users have provide the raw data Excel file but this is
haphazard and unreliable due to the fact that humans are lazy and take
holidays!

The application that produces the raw data Excel file can now be
configured to send the raw data Excel file via email but for full
automation I need this file on the network and not in an email inbox.

My company uses MS Exchange Server (not sure what version) so my
question is this: Is it possible to set up MS Exchange Server to
monitor an email account and when emails arrive automatically download
any attachments to a network location?

Thanks in advance for any pointers or help,
Chrisso
Hi

I would check to see if the program that is exporting this raw data can
save it via a Delimited .csv/.txt file format saving it directly to your
network drive location where you can access/import it automatically there.

HTH
Mick.

Auto download of Excel files in emails
 

Thanks Mick

On Monday, June 11, 2012 3:54:51 PM UTC+1, Vacuum Sealed wrote:
On 11/06/2012 7:31 PM, Chrisso wrote:
Hi - sorry for posting in this group as sure this is not quite the
right group but only related. However I cannot find a better group and
have always had helpful replies in this group.

I have an Excel reporter that gets it's raw data from another
application in the form of another Excel file. My reporter imports the
data and presents charts etc.

At the moment users have provide the raw data Excel file but this is
haphazard and unreliable due to the fact that humans are lazy and take
holidays!

The application that produces the raw data Excel file can now be
configured to send the raw data Excel file via email but for full
automation I need this file on the network and not in an email inbox.

My company uses MS Exchange Server (not sure what version) so my
question is this: Is it possible to set up MS Exchange Server to
monitor an email account and when emails arrive automatically download
any attachments to a network location?

Thanks in advance for any pointers or help,
Chrisso
Hi

I would check to see if the program that is exporting this raw data can
save it via a Delimited .csv/.txt file format saving it directly to your
network drive location where you can access/import it automatically there.

HTH
Mick.

Thanks Mick but that avenue is a dead end. We can only get in an email.

Chrisso