View Single Post
  #3  
Old June 18th 09, 09:38 PM posted to microsoft.public.outlook.program_vba
Gee
external usenet poster
 
Posts: 5
Default Send Mail If Statement

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

On Jun 18, 12:07 am, Gee wrote:
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


Ads