Autosave attachment and create text file based on information in email.



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.

.


Loading