![]() |
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
|
|||
|
|||
![]() This is the macro to stop sending without a subject as well as to warn the user whn he sends to the distribution list that starts with "#" However this code detects the email addresses in TO / CC as one single string. For eg if i have shreekanth Murali; #IN - distribution then it detects "shreekanth murali; #in - distribution" and not warning the presence of a distributon list in TO field... Im a beginner please lemme know how can i do it Private Sub Application_ItemSend(ByVal item As Object, Cancel As Boolean) Dim strSubject As String strSubject = item.Subject If Len(Trim(strSubject)) = 0 Then Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?" If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then Cancel = True End If End If Dim a Dim b a = Mid(item.To, 1, 1) If a = "#" Then Prompt$ = "You are about to send an email to the distribution list " & item.To If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Recipient is a distribution list") = vbNo Then Cancel = True End If End If End Sub Submitted via EggHeadCafe - Software Developer Portal of Choice CSS Stylesheet Sampler Script http://www.eggheadcafe.com/tutorials...ampler-sc.aspx |
#2
|
|||
|
|||
![]()
Instead of using To/CC/BCC properties, loop through all the recipients in
the MailItem.Recipients collection. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - Shreekanth Murali wrote in message ... This is the macro to stop sending without a subject as well as to warn the user whn he sends to the distribution list that starts with "#" However this code detects the email addresses in TO / CC as one single string. For eg if i have shreekanth Murali; #IN - distribution then it detects "shreekanth murali; #in - distribution" and not warning the presence of a distributon list in TO field... Im a beginner please lemme know how can i do it Private Sub Application_ItemSend(ByVal item As Object, Cancel As Boolean) Dim strSubject As String strSubject = item.Subject If Len(Trim(strSubject)) = 0 Then Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?" If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then Cancel = True End If End If Dim a Dim b a = Mid(item.To, 1, 1) If a = "#" Then Prompt$ = "You are about to send an email to the distribution list " & item.To If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Recipient is a distribution list") = vbNo Then Cancel = True End If End If End Sub Submitted via EggHeadCafe - Software Developer Portal of Choice CSS Stylesheet Sampler Script http://www.eggheadcafe.com/tutorials...ampler-sc.aspx |
#3
|
|||
|
|||
![]()
Can you please guide me by giving me an example how to use this.... I am sorry i need to agree that i have just started to learn... i need your help please... we are gonna apply this for our people in my company...
Dmitry Streblechenko wrote: Instead of using To/CC/BCC properties, loop through all the recipients inthe 18-Dec-09 Instead of using To/CC/BCC properties, loop through all the recipients in the MailItem.Recipients collection. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - Shreekanth Murali wrote in message Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET Digest Authentication Against Database http://www.eggheadcafe.com/tutorials...uthentica.aspx |
#4
|
|||
|
|||
![]()
item.recipients.Count gives me number of recipients in the mail. How can i get the details of that . What should i user.
eg: I have three email address in to field and for testing purpose i wrote msgbox(item.recipients.count) and this gave me 3 in the msgbox. Now how can get the recipients? i can create a loop but what property should i use to extract this ? iam using O2k3 Shreekanth Murali wrote: example please 19-Dec-09 Can you please guide me by giving me an example how to use this.... I am sorry i need to agree that i have just started to learn... i need your help please... we are gonna apply this for our people in my company... Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Toward Viable CAPTCHA Alternatives http://www.eggheadcafe.com/tutorials...ptcha-alt.aspx |
#5
|
|||
|
|||
![]()
Hey I found it
its item.recipients.item(i).AddressEntry THANKS A LOT FOR YOUR INFORMATION. Shreekanth Murali wrote: item.recipients.Count 20-Dec-09 item.recipients.Count gives me number of recipients in the mail. How can i get the details of that . What should i user. eg: I have three email address in to field and for testing purpose i wrote msgbox(item.recipients.count) and this gave me 3 in the msgbox. Now how can get the recipients? i can create a loop but what property should i use to extract this ? iam using O2k3 Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice axWebBrowser1.Navigate Auto Page Loader In A Real Browser http://www.eggheadcafe.com/tutorials...vigate-au.aspx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2007 To field not caching recipients | mdlister | Outlook - General Queries | 5 | July 2nd 09 10:46 AM |
How do I change data in a field across an array of contacts? | Max's Dad in Traverse | Outlook - Using Contacts | 1 | January 11th 08 07:45 PM |
All recipients aren't showing up in the To: field | fielix | Outlook - General Queries | 3 | June 25th 07 03:45 PM |
Sending to specific recipients, field populates with time/date? | faeriegirl | Outlook - Using Forms | 3 | July 28th 06 12:19 AM |
Copy and paste recipients list into To field of new email message displays as ; | [email protected] | Outlook - General Queries | 0 | March 9th 06 05:19 PM |