detach a txt file from a note & copy text into spreadsheet
Posted on 2006-04-26
Please can you help!
Also, Please don't provide a big chunk of lotusscript code as i dont understand it.
If possible I would like to do this using @commands/functions.
I am wishing to create an agent to transfer data in a txt file and
automatically place it into a spreadsheet (excel or lotus 123 it doesnt
I have an excel file already with just the column headers and
formatting so excel would be better.
I have mail sent to me on a regular basis during the day. Each note
contains a text file such as below: -
I want the agent to do the following: -
1. When 'new mail' arrives in folder "FOLDER_A" run agent
2. Open the attached txt file and copy each line after the '=' sign
into the spreadsheet.
I would like to do this using simple actions or commands as my
Lotusscript is not very good !!
Any help anyone could pass on would be really useful to me.