A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old September 1st 06, 11:50 PM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 4
Default 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 sheet"
that contains the document information (file number, document type). I
use the lead sheet as the first page of the document I am scanning and
my system will use OCR to read the info on the lead sheet and it will
file it based on that info. Problem is the OCR runs into too many
problems. If the lead sheet 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.

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set the file attachment options to show above text? How do i set file attachment? Outlook - General Queries 1 July 24th 06 08:47 PM
Possible to create rule that uses keywords located in a text file? CodeKid Outlook and VBA 5 June 28th 06 08:12 PM
Create a new contact list from a text file Janet W Outlook - Using Contacts 1 June 12th 06 04:43 PM
AutoSave Zip File Telecommm Outlook and VBA 2 January 19th 06 09:50 AM
How to create a distribution list based on contents of a text file yjwonder Outlook - Using Contacts 1 January 9th 06 11:12 PM


All times are GMT +1. The time now is 09:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright Đ2004-2025 Outlook Banter.
The comments are property of their posters.