Automatically send a report (1 Viewer)

MaleNurse325

Registered User.
Local time
Yesterday, 17:55
Joined
Jan 11, 2016
Messages
67
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

MVP / VIP
Local time
Today, 00:55
Joined
Jan 14, 2017
Messages
18,186
Add code to the after update event of your textbox such as:

Code:
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

..forever waiting... waiting for jellybean!
Local time
Today, 08:55
Joined
May 7, 2009
Messages
19,169
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
 

Users who are viewing this thread

Top Bottom