July 1st 09, 07:45 PM
posted to microsoft.public.outlook.program_vba
|
|
|
Send Mail If Statement
See http://www.codeforexcelandoutlook.co...ok-automation/
for sample code.
--JP
On Jun 28, 7:31*pm, Gee wrote:
OH, help, HOW do I use the MailItem.Send method and WHERE do I use it? *I'm
so confused!
"Gee" wrote:
Is that instead of "DoCmd.SendObject"?
This is the code I'm using now...what would change please?
If NOC = "300" Then
DoCmd.SendObject acSendReport, "NOCR", acFormatSNP, Me.Text39, , , "NOC
AGING", Me.CallNo, , False
End If
"JP" wrote:
You should be able to use the MailItem.Send method. Keep in mind this
will not display the email, just send it. Beware the Object Model
Guard.
HTH,
JP
|