Script for sending email via Microsoft Outlook

[JD2775]

Hi guys,

I am creating a fairly basic Maintenance Database at my work. The database has 2 layouts, one where you record issues as you see them, and the other is a DataLog table that has all the issues that have been recorded.

One of the fields in the DataLog table is "Resolved" and I have it set as a radio "Yes/No" button. What I want to have happen is when a user clicks "Yes" an automated email pops up with a set list of email addresses (I know how to do that part) and within the body of the email all the information for that current record, or as an attached PDF, either way. There are 6-7 fields for each record. For sake of ease let's call them Field1 - Field7.

Is this possible to do? If so, any guidance on how to get started? If it makes it easier, I can attach the Database here if that works.

Thanks

[bcooney]

You can set the body of an email to a field. Therefore, you need to concatenate the fields:

AllFields = field1 & " " & field2 & " " ...

I don't typically use Yes/No, but rather just a checkbox flag_Resolved. This is set to a value list which is simply just "1" (Make the checkbox width narrow to hide the label). Clicking the checkbox could run a script trigger that creates the email.