Email Notification with Record ID

[randallst]

Hi There,

I want to create a button on my form so that once I have entered results of an Audit into the form, I want to be able to press the button to send the manager an email stating the Audit Observation Record ID to action.

Is there a way of doing this? This would save a lot of admin if so

All the best
Stu

 

[pbaldy]

Simplest would probably be SendObject, using the form control containing the desired value.

 

[randallst]

Is there a way of it just entering the ID into an automated email, for example;

Dear Joe Bloggs,

Please note that an audit has been carried out. Please review Audit ID 99 and provide feedback where possible.

Kind Regards
John Smith

 

[pbaldy]

Yes, using a string variable that you later use with SendObject:

Variable = "Blah blah" & Me.TextboxName & vbCrLf & "more blah here"

vbCrLf adds a return.

 

[randallst]

I've never done something like this before so apologies for sounding stupid.
How would I write this and where?

I am guessing from what you have wrote about I need to write something along the lines of;

"Please note that an audit has been carried out. Please review Audit ID" & Me.ID & vbCRLf "and provide feedback before the Target Date of Closure."

 

[pbaldy]

Along the lines of:

Dim strBody as String

strBody = "Dear Joe Bloggs, " & vbCrLf & vbCrLf & "Please note..." & Me.ID & " more here"

DoCmd.SendObject acSendNoObject,"",,"blah@blah.com",,,"subject", strBody, True

 

[pbaldy]

Oh, and code goes here:

http://www.baldyweb.com/FirstVBA.htm