How do I extract attachments automatically?

  • Thread starter Thread starter AU_BTS
  • Start date Start date
A

AU_BTS

The group of people I work with and myself all recieve tasks through a public
folder in outlook. I have set it up with a rule so when a message with an
attachment is sent to this public folder it is automatically sent to a
personal folder under my inbox. What I would like to do is have outlook send
only the attachments (all of which are excel spreadsheets formated the same
way) to a folder on my desktop.

It is outside the scope of this forum, but I would also like to have VB take
the first nine characters of the file name and make that into the displayed
text for a hyperlink in an excel spreadsheet in the first available cell in a
given column. This hyperlink would lead from this excel spreadsheet to the
folder which Outlook was automatically sending the attachments.

I know what I want, but not how to get there, any information on how to do
this with as little VB skills as possible would be outstanding as my VB
skills are limited at best. This seems like it would need to be two seperate
scripts, one from Outlook to move the attachments and another from Excel to
name and establish the hyperlink.

Thank you for your time.
 
These code samples show various ways to save attachments:

http://www.fontstuff.com/outlook/oltut01.htm
http://www.outlookcode.com/codedetail.aspx?id=70
http://www.outlookcode.com/codedetail.aspx?id=866
http://www.outlookcode.com/codedetail.aspx?id=1494
http://www.slovaktech.com/code_samples.htm#StripAttachments

There's no reason the Excel automation code couldn't be combined with the
attachment saving code into the save Outlook procedure, but an Excel group
can probably help you more effectively with such tasks as opening a worksheet
and finding the first blank cell.
 
Back
Top