Automatically extract attachments?
 

The "imagined" scenario.

The company has a template Excel file called StufToDo.Xls they give all
their external PMs. Daily or weekly the PMs send an email. The email
body is not important, they might write "Here ya go!" or leave it blank.
It is the attached Excel template to their email is important.

Corporate creates an Outlook email account called Stuff and the PMs send
all StufToDo emails to that account.

Corporate creates an email account on the network called Stuff. The
inbox for Stuff also has an inbox subfolder called Done.

When Outlook receives an email in that account, it looks to see if it
has a StufToDo Excel file. If so, it copies the Excel file to that
folder and then moves the email to the Done folder.

Since the file name StufToDo.Xls may already exist in that folder, and I
don't want it overwritten, Outlook generates a unique name for it to
copied to.

I suppose daily a user could check to see if any emails didn't get
processed or didn't fit the format, but overall there should be little
need for human intervention.

Can this be done? Easily? Or...are there any books or sources that may
describe something similar so I could see how it is done?

Also, would a computer need to have Outlook opened or could this be done
in the "background",

Thanks for any replies.

Automatically extract attachments?
 

The hard way is to write a service that is running on the server, there's no
VBA possible. Easier is it with some VBA code running in Outlook, which of
course means that Outlook must be running.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Fri, 26 Jun 2009 06:05:55 -0700 schrieb Salad:

The "imagined" scenario.

The company has a template Excel file called StufToDo.Xls they give all
their external PMs. Daily or weekly the PMs send an email. The email
body is not important, they might write "Here ya go!" or leave it blank.
It is the attached Excel template to their email is important.

Corporate creates an Outlook email account called Stuff and the PMs send
all StufToDo emails to that account.

Corporate creates an email account on the network called Stuff. The
inbox for Stuff also has an inbox subfolder called Done.

When Outlook receives an email in that account, it looks to see if it
has a StufToDo Excel file. If so, it copies the Excel file to that
folder and then moves the email to the Done folder.

Since the file name StufToDo.Xls may already exist in that folder, and I
don't want it overwritten, Outlook generates a unique name for it to
copied to.

I suppose daily a user could check to see if any emails didn't get
processed or didn't fit the format, but overall there should be little
need for human intervention.

Can this be done? Easily? Or...are there any books or sources that may
describe something similar so I could see how it is done?

Also, would a computer need to have Outlook opened or could this be done
in the "background",

Thanks for any replies.