I am creating a small mailer program in which I need to populate to memory variable lcsubject and lcbody. In the subject field I want to insert some information from a table. Therefore I have a function which can look up any table for the key and give the value in the field.

Therefore stored in the table email.subject is the following:

A new style has been created for mainkey: FieldLookup("mainkey","moc031",)

When I run my program I want to execute the FieldLookup program. The program works fine stand alone.

Can anybody show me how I can execute this program when running my form on this email?

Thanks