Message box on macro

[Wayne-I-M]

Hi

I am running a macro on windows scheduler. The macro just remind a specific
manager (how keeps forgeting) to run a report. I don't want to automate the
running of the report as there are times when it should not run.

I can run a macro from schedular but (as I don't use macros hardly ever) not
really sure how to get the message box to run from the macro.

I can get a little popup box just saying ...text.... yes.

But the message box it just a little more than this

msg = "Message from Wayne." & strID & vbCrLf & vbCrLf & "Do you want
to send the stats reports now?"
style = vbYesNo
title = "Monday morning 10am"
responce = MsgBox(msg, style, title)
If responce = vbYes Then
DoCmd.OpenForm "frmWeeklyStatsReportSelector", acNormal, "", "", ,
acNormal
End If

How can a load this into a macro?

Thank you

 

[Wayne-I-M]

Its OK

I got it.