Need help writing a macro for when a value is changed in my form (send an email)

[rayted]

Hi all,



I am desperate for basic help with writing a macro.

I am creating a mini IT support system.

When using the form (see image attached), I want an email notification to be sent when a new ticket has been opened (this could perhaps be using ID, or opened date.

I have tried researching and writing macros but nothing works! can someone please help?

[ranman256]

i guess in your SAVE and NEW button....or email btn.

sub btnSaveAndNew_Click()
dim sTo as string, sSubj as string , sBody as string

sTo = txtEmail
sSub = "case# " & txtID 
sBody = "your problem has been logged"

'if msgbox("Send email") = vbYes then
    docmd.SendObject acSendForm ,"frmMyForm",acFormatPDF,sTo,,,sSubj,sBody
'endif
end sub

[rayted]

Thanks Ranman - is there a way in which I can edit the output (it is saving too many screenshots - and as a pdf at the moment). This is all good progress though... thanks!

[ranman256]

send the report version:
docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody