MAcro - Need help in getting the recipients in to filed / cc field toput in an array

Status
Not open for further replies.
S

Shreekanth Murali

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

CSS Stylesheet Sampler Script

http://www.eggheadcafe.com/tutorial...0-64466ee722bc/css-stylesheet-sampler-sc.aspx
 
D

Dmitry Streblechenko

Re: MAcro - Need help in getting the recipients in to filed / cc field to put in an array

Instead of using To/CC/BCC properties, loop through all the recipients in

the MailItem.Recipients collection.

Dmitry Streblechenko (MVP)

-

<Shreekanth Murali> wrote in message

news:20091218121113sirmurali@yahoo.com...

> 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

> CSS Stylesheet Sampler Script
> http://www.eggheadcafe.com/tutorial...0-64466ee722bc/css-stylesheet-sampler-sc.aspx
 
S

Shreekanth Murali

example please

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)

-

<Shreekanth Murali> wrote in message

Previous Posts In This Thread:

ASP.NET Digest Authentication Against Database

http://www.eggheadcafe.com/tutorial...af-8a9a5c91c0d6/aspnet-digest-authentica.aspx
 
S

Shreekanth Murali

item.recipients.Count

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:

Toward Viable CAPTCHA Alternatives

http://www.eggheadcafe.com/tutorial...c-a34cd08623e8/toward-viable-captcha-alt.aspx
 
S

Shreekanth Murali

I Found it -->item.recipients.item(i).AddressEntry

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:

axWebBrowser1.Navigate Auto Page Loader In A Real Browser

http://www.eggheadcafe.com/tutorial...4f-4a6dbf0c2d91/axwebbrowser1navigate-au.aspx
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
C Eliminate need for "Enable Macro" selection Outlook VBA and Custom Forms 7
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 2
S Macro for Loop through outlook unread emails Outlook VBA and Custom Forms 2
Globalforester ItemAdd Macro - multiple emails Outlook VBA and Custom Forms 3
S Macro to extract email addresses of recipients in current drafted email and put into clipboard Outlook VBA and Custom Forms 2
witzker HowTo start a macro with an Button in OL contact form Outlook VBA and Custom Forms 12
witzker Macro to move @domain.xx of a Spammail to Blacklist in Outlook 2019 Outlook VBA and Custom Forms 7
S Macro for other actions - Outlook 2007 Outlook VBA and Custom Forms 23
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
L Macro/VBA to Reply All, with the original attachments Outlook VBA and Custom Forms 2
S Macro to move “Re:” & “FWD:” email recieved the shared inbox to a subfolder in outlook Outlook VBA and Custom Forms 0
S Outlook Macro to send auto acknowledge mail only to new mails received to a specific shared inbox Outlook VBA and Custom Forms 0
S Outlook Macro to move reply mail based on the key word in the subjectline Outlook VBA and Custom Forms 0
Eike Move mails via macro triggered by the click of a button? Outlook VBA and Custom Forms 0
S Macro or plug-in to see if specific person was included in this email Outlook VBA and Custom Forms 4
U Macro for reminders,tasks,calendar Outlook VBA and Custom Forms 4
V macro runs slower on startup than after Outlook VBA and Custom Forms 3
N Macro to move all recipients to CC while replying Outlook VBA and Custom Forms 0
A VBA macro for 15 second loop in send and received just for 1 specific mailbox Outlook VBA and Custom Forms 1
G VBA Macro Calendar Printing Assistant 4
R Help Revising VBA macro to delete email over different time span Outlook VBA and Custom Forms 0
M Outlook macro to automate search and forward process Outlook VBA and Custom Forms 6
R Macro Schedule every day in Outlook Using Outlook 0
L Moving emails with similar subject and find the timings between the emails using outlook VBA macro Outlook VBA and Custom Forms 1
Healy Consultants Macro to remove inside organization distribution list email address when reply to all recepients Outlook VBA and Custom Forms 0
geofferyh Cannot get Macro to SAVE more than one message attachment??? Outlook VBA and Custom Forms 5
N How can I increase/faster outlook VBA Macro Speed ? Using Outlook 2
4 Macro to set the category of Deleted Item? Outlook VBA and Custom Forms 2
D.Moore Folder view settings by VBA macro Outlook VBA and Custom Forms 57
A Outlook macro to create search folder with mail categories as criteria Outlook VBA and Custom Forms 3
Dave A Run macro on existing appointment when it changes Outlook VBA and Custom Forms 1
V Outlook Macro to show Flagged messages Outlook VBA and Custom Forms 2
O Run macro automatically at sending an email Using Outlook 11
R Retain Original Message When Forwarding With Macro Outlook VBA and Custom Forms 3
C Macro to add multiple recipients to message Outlook VBA and Custom Forms 3
B Reply and replyall macro is not working Outlook VBA and Custom Forms 1
O Macro - paste as plain text Outlook VBA and Custom Forms 2
J Help Please!!! Outlook 2016 - VBA Macro for replying with attachment in meeting invite Outlook VBA and Custom Forms 9
witzker Macro to set contact reminder to next day 9:00 Outlook VBA and Custom Forms 45
M Adding Macro to populate "to" "subject" "body" not deleting email string below. Outlook VBA and Custom Forms 5
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
R VBA macro - new message Outlook VBA and Custom Forms 3
S Example VBA Macro - To Conditionally Change the From Account and Add a BCC Address on Emails Outlook VBA and Custom Forms 11
S Macro using .SendUsingAccount only works the first time, after starting Outlook Outlook VBA and Custom Forms 4
S VBA Macro - Run-time error '424': object required - Help Please Outlook VBA and Custom Forms 3
B VBA Macro for assigning multiple Categories to an email in my Inbox Outlook VBA and Custom Forms 1
N Macro for attachment saved and combine Outlook VBA and Custom Forms 1
Sabastian Samuel HOW DO I FORWARD AN EMAIL WITH MACRO using an email that in the body of another email Outlook VBA and Custom Forms 3
C Search with Google Macro? Outlook VBA and Custom Forms 4

Similar threads

Top