auto populate email field

Jarno - there are a few ways to do it but a simple way from buttons etc

This one of the ays I do it on my job dockets forms

So on my my customer card Table I have a field called email

now on my Jobdockets table every time i enter a job I want the email field to auto fill in the email form the main customer card...and like you i want it to fire my standard outlook client.

so in the trigger on new record in the Jobdocket form form I simply put

Customers.Email

ignore the other bit of code in my screen shot ... "let before etc" as that relates to me auto numbers jobs

Not you can auto add attachments using Send Mail (Ninox's in built email system)

I use both methods very successfully

ie on my job bags 

I send order Acks & Order dispatched etc

and thanks you for ordering with us (plus a pdf advert)

..

With the out look method I call outlook then have several preset signature letter preset..

ie Debt Chase letters etc...

Jarno

You said you want to copy the email from a linked table ? as along as you have a link you should be able to extra the email from the other table record.

Re attachments

Here is the script from my customer (goods dispatched button) using SendEmail

This gives calls one of my letters which are stored in a table that holds customer letters templates (SystemFile). Then sends the appropriate message notification plus adds an attachment (advert) (see bold lines)

should be fairly self explanatory ! 

if Status < 2 or Status > 3 then
    alert("job Status is not in production")
else
    Status := 3;
    if not 'Email+' then
        alert("No valid contact in email field")
    else
        if DispFlag = 1 then
            alert("Dispatched Confirmation already sent!")
        else
            let thisBody := first((select SystemFile).OrderDispatchedLetter);
            let myEmail := userEmail();
            let myAtt := first(files(record(SystemFile,1)));
            thisBody := replace(thisBody, "{Ord Company}", text('Ord Company'));
            thisBody := replace(thisBody, "{Order Name}", text('Order Name'));
            thisBody := replace(thisBody, "{Job Bag}", text('Job Bag'));
            thisBody := replace(thisBody, "{Order Date}", text('Order Date'));
            thisBody := replace(thisBody, "{Order Name}", 'Order Name');
            thisBody := replace(thisBody, "{Order Ref}", 'Order Ref');
            thisBody := replace(thisBody, "{Qty}", text(Qty));
            thisBody := replace(thisBody, "{Desc}", Desc);
            thisBody := replace(thisBody, "{Del Company}", text('Del Company'));
            thisBody := replace(thisBody, "{Del Address}", text('Del Address'));
            DispFlag := 1;
            sendEmail({
                from: myEmail,
                to: 'Email+',
                subject: "Your order has been dispatched by 118 Printgroup",
                text: "Goods Dispatched Confirmation",
                html: thisBody,
                attachments: myAtt
            });
            alert("Goods Dispatched Email has been Sent");
            DisplayMenu := 1
        end
    end
end