We are running a WSS site with several document libraries. When our users send emails to a certain document library in the subject field of the email they put the company name which becomes the destination folder in the library. So, if someone sending an email to the document library email address puts MYNEWCOMPANY in the subject line, such email with the attached files is placed by WSS under MYNEWCOMPANYNAME folder in the document library. If such folder doesn't exist, it is created automatically.
This library also contains a KEY field (column) which users then have to update manually in a spreadsheet mode directly on WSS page. This field is actually serving as a link between files. For example, to link documents and emails related to the same order or RFQ. Is there a way to automate this procedure so that users will add for example '/' between company name and description of the KEY in the email subject so that in the WSS this KEY description will be automatically copied to KEY filed so that they will not have to open document library and manually insert this descriptions each time after sending an email to a document library? Or there might be some better workaround to this problem?
For example, the library contains the following columns:
Type, Name, ModifiedBy, Document Type, KEY
When user will place in subject the string like 'CompanyName / Keytxt ' sharepoint will place the email with all the attached files into 'CompanyName' folder and 'Keytxt' in KEY column?