Are there scripts in Outlook and if so can they do what is in mess

  • Thread starter UHJvZ0Rlc2lnbg
  • Start date Views 715
Status
Not open for further replies.
U

UHJvZ0Rlc2lnbg

I just uncovered a potential project and I would like your opinion on it.
This involves Microsoft Outlook, which I don't know much about. We receive
over 500 emails a month with attachments, in two of our email boxes where the
attachments need to be saved on our network. Right now this process is being
done manually and is very time consuming, because it is not as easy as it
sounds. I would like to automate this process.

Here are a couple of the problems.
1. Many of the attachments have the same name so the automated process would
have
to append a date to the filename before it is saved.

2. The date of the email is not necessarily the date that needs to be on the
saved
document. The date is within the body of the attachment. Also we get
reports from
several operators, so the date field is not always in the same place or
in the same
application.

Anyway, to be brief there are other problems.

My question is, is there any type of script or other application, that you
can use on
Microsoft Outlook that will open attachments, rename files, and search for
date fields to append to file names? Also, we are a small company, so any
kind of data warehousing may not be cost effective at this time.

Thanks,
 
U

U3VlIE1vc2hlciBbTVZQXQ

These samples show various ways to save attachments with code:

http://www.fontstuff.com/outlook/oltut01.htm
http://www.outlookcode.com/codedetail.aspx?id=70
http://www.outlookcode.com/codedetail.aspx?id=1494
http://www.slovaktech.com/code_samples.htm#StripAttachments
http://www.outlookcode.com/codedetail.aspx?id=1926
http://www.outlookcode.com/codedetail.aspx?id=866 -- VBA with Windows API
calls to display the file folder selection dialog

Check at http://www.slipstick.com for add-ins for this purpose.

FYI, there is a newsgroup specifically for general Outlook programming
issues "down the hall" at microsoft.public.outlook.program_vba or, via web
interface, at
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

Sue Mosher,

"ProgDesign" wrote:

> I just uncovered a potential project and I would like your opinion on it.
> This involves Microsoft Outlook, which I don't know much about. We receive
> over 500 emails a month with attachments, in two of our email boxes where the
> attachments need to be saved on our network. Right now this process is being
> done manually and is very time consuming, because it is not as easy as it
> sounds. I would like to automate this process.
>
> Here are a couple of the problems.
> 1. Many of the attachments have the same name so the automated process would
> have
> to append a date to the filename before it is saved.
>
> 2. The date of the email is not necessarily the date that needs to be on the
> saved
> document. The date is within the body of the attachment. Also we get
> reports from
> several operators, so the date field is not always in the same place or
> in the same
> application.
>
> Anyway, to be brief there are other problems.
>
> My question is, is there any type of script or other application, that you
> can use on
> Microsoft Outlook that will open attachments, rename files, and search for
> date fields to append to file names? Also, we are a small company, so any
> kind of data warehousing may not be cost effective at this time.
>
> Thanks,

 
Status
Not open for further replies.

Similar threads

Top