I need to automate the following:
1. Emails are received with MSExcel attachments containing data.
2. The data is then manually input into an OASIS database.
Is there any way of automating all this, using progress ?
Help, please.
the below code will help
DEFINE VARIABLE vname AS CHARACTER NO-UNDO.
DEFINE VARIABLE vname2 AS CHARACTER NO-UNDO.
DEFINE VARIABLE vname3 AS CHARACTER NO-UNDO.
INPUT FROM "c:\a1.xls".
/* the delimiter is TAB */
IMPORT DELIMITER " " vNAME vname2 vname3.
MESSAGE vname vname2 vname3
VIEW-AS ALERT-BOX INFO BUTTONS OK.