Send Mail If Statement

  • Thread starter Thread starter Gee
  • Start date Start date
G

Gee

I need to automatically send and email if the subject line is "NOC".

I'm sending from an Access database and what I need is for when the
completed email pops up, to not have to click the "Send" button.

I think it should be some kind of Macro or IF statement in Outlook's VBA?

Thank you in advance for any help you can give me.

Gee
 
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
 
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
 
Sorry, this is the Outlook VBA newsgroup so I assumed you were
instantiating Outlook, not using Access' built in sending commands.
That's the only way I know of where you can send emails without having
to hit Send.

--JP
 
Back
Top