Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 259
Default 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.
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Taking out unsubscribed emails by comparing 2 Excel files (Excel 2003) Julie - Excel beginner Excel Discussion (Misc queries) 1 May 8th 07 06:41 PM
how to stop emails incoming its taking a long time to download emails incoming New Users to Excel 1 June 25th 06 03:24 AM
Embedding excel files into Outlook emails lithium81[_7_] Excel Programming 1 December 16th 05 09:31 AM
Can Excel download files? elbalazo Excel Programming 2 August 24th 04 07:14 PM
Download files with excel Mangda Excel Programming 0 October 14th 03 09:08 AM


All times are GMT +1. The time now is 06:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"