Autosave attachment and create text file based on information in email.
- From: rligouri@xxxxxxxxxxxxxxxxxxxxx
- Date: 1 Sep 2006 14:50:56 -0700
I use a document imaging system that uses OCR to file documents I scan
into it. For every document I scan in, I have to print a "lead ***"
that contains the document information (file number, document type). I
use the lead *** as the first page of the document I am scanning and
my system will use OCR to read the info on the lead *** and it will
file it based on that info. Problem is the OCR runs into too many
problems. If the lead *** isnt perfectly straight, the ink too light,
there is a mark on the scanner or many others, the document will not
file properly. I contacted my software vendor and they said they will
come up with an alternative and they added the ability for the system
to process metadata files. The metadata file is a file created by some
scanners when you scan a document that contains user inputted
information. I could input the file number and document type right from
the scanner and a .DAT file (metadata file) will accompany the scanned
file telling the system how to file document. Next problem is my
scanners do not have this feature.
I've brainstormed and I came up with an idea to create the metadata
file.Create an email with the document attached and the file
information in the subject line. Send the email to a computer with
outlook always running on it. Using a combination of rules and vba,
outlook will do the following:
1) Save the attachment to a specific directory. I need to target only
TIFF files as my that is the only format my system can handle.
2) Create a text file containing information from the subject line
and/or body and the attachment file name of the email and save it as a
..DAT file in the same directory as where the TIFF file was saved.
The metadata file has to be formated like
xxxxxxxxxYYYYYYYYYYYYzzzzzzzzzzzzz. With x being the file number, Y
being the document type, and z being the path of the TIFF file. The
file name need to be formatted as IT#.dat, with # being a random
generated number to avoid duplicates.
Any help would be greatly appreciated.
.
- Follow-Ups:
- Re: Autosave attachment and create text file based on information in email.
- From: Michael Bauer [MVP - Outlook]
- Re: Autosave attachment and create text file based on information in email.
- Prev by Date: Re: Outlook not always executes an script from a rule
- Next by Date: How to call Outlook "New Mail Mesage" Dialog via Outlook Object Model?
- Previous by thread: Re: Outlook not always executes an script from a rule
- Next by thread: Re: Autosave attachment and create text file based on information in email.
- Index(es):
Loading