|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
June 18th 09, 05:07 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Send Mail If Statement
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 |
|
#2
June 18th 09, 07:45 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Send Mail If Statement
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
|
|
#3
June 18th 09, 09:38 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#4
June 29th 09, 12:31 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Send Mail If Statement
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 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
|
|
#5
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| if statement | Joel Allen | Outlook and VBA | 3 | May 18th 09 10:49 PM |
| Iif statement on mail form | Sandi V | Outlook - Using Forms | 1 | November 17th 08 10:00 PM |
| Word Macro Conditional Statement | hometeamjill | Outlook and VBA | 1 | March 24th 08 12:59 PM |
| If then statement | Aggie G | Outlook - Using Forms | 3 | February 2nd 07 07:50 PM |
| Send Exchange mail first than send mail in local Laptop. | Ratnam | Outlook - General Queries | 0 | October 8th 06 12:24 PM |
Linear Mode
