lotus notes agent using formula language to populate an excel spreadsheet
Posted on 2006-04-26
Please can anyone help with the following: -
I am being sent email from all users in the department which is filtered into a folder, "FOLDER_A".
All documents in this folder contain a file "doc.txt".
This is field data from a form which looks like this: -
TAXI REASON=Client Job
COMMENTS=Arrived at 06:00hrs
I am trying to create an agent in My mail client that will do the following: -
1. Search a designated folder (FOLDER_A) for 'new mail'
2. Take the data (as above) from the document
2a - I want this to take all data 'after' the = sign
3. Copy this data into an excel spreadsheet
The spreadsheet already exists (MAILSPREADSHEET) on my workstation locally.
The column headings are what is to the left of the = sign shown on the data above.
I know what I want to do but not to go about it.
I am not very good with Lotusscript and would therefore like to tackle it using @Formula language.
I have just started the agent and created a simple action for the 'Document Selection' which is "in folder 'FOLDER A'."
I would like to do all the steps above, and when the agent has copied the data from the 'new mail' within the folder, then auto archive the mail.
Any advice would be appreciated