• Subject: Re: What sort of group?
  • Author: Jay Brigand
  • Date: 12 Apr 2011
  • References: 1
Hi,

I'm actually looking to set up something similar.

Ideally, I want to get something set up so that if I write an email and address it to the Distribution Group "All Users" it will come up with a pop up asking me to confirm if I want to send it with a yes or no button.

Ideally, it would be something similar to the below code but for checking if it is being sent to the distribution list instead of having an attachment:

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
'
If InStr(1, Item.Body, "attach", vbTextCompare) > 0 Then
If Item.Attachments.Count = 0 Then
ans = MsgBox("There's no attachment, send anyway?", vbYesNo)
If ans = vbNo Then Cancel = True
End If
End If
End Sub

Any help would be greately appreciated.
- J

> On Tuesday, October 26, 2010 2:43 PM Gurvinder wrote:

> Is there any way to check via VBA if the recipient is a specific group
> or keywords before sending any email to bring up a pop-up saying "Are
> you sure you want to send this message to a group"
>
> Saving you lapse in picking the wrong group to send emails to.
>
> Outlook 2007 - Exchange 2003.
>
> Thanks in advance.


>> On Tuesday, October 26, 2010 6:27 PM Ken Slovak wrote:

>> What sort of group? Do you mean an Outlook distribution list, or one in an
>> Exchange GAL, or ...?
>>
>> It would also depend on whether or not a distribution list, if that is what
>> you are talking about, is expanded or not.
>>
>> What about keywords? Do you mean categories, or what? Please explain.
>>
>> --
>> Ken Slovak
>> [MVP - Outlook]
>> http://www.slovaktech.com
>> Author: Professional Programming Outlook 2007.
>> Reminder Manager, Extended Reminders, Attachment Options.
>> http://www.slovaktech.com/products.htm
26 Oct 2010Checking Recipient Group before sending email via VBA.Gurvinder
26 Oct 2010\ Re: Checking Recipient Group before sending email via VBA.Ken Slovak
12 Apr 2011   \ Re: What sort of group?.Jay Brigand
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)