Automatically send a report

[MaleNurse325]

I have a form on which there is a text field that will return a value or accept or decline.
In the event that 'Decline' is selected, I'd like to have an email sent to notify the manager if 'Decline' is selected. Any ideas guys ?

 

[isladogs]

Add code to the after update event of your textbox such as:

If Me.textboxname="Decline" Then
'add your code to send an email here
End If

If you don't have email code, search this forum or google it - loads of examples online

I pity your poor manager with all the emails he/she's going to get

 

[arnelgp]

have a commandbutton on your form, so when you see it is 'Declined' you can press this button to send the report.

private sub button_Click()
docmd.SendObject OutputFormat:=acFormatPDF,To:=agpuzon@gmail.com,Subject:="Declined",MessageText:="your MessageHere"
end sub