Consulting

Results 1 to 2 of 2

Thread: Please help, prompt msgbox when TO and or CC field NOT empty

  1. #1

    Please help, prompt msgbox when TO and or CC field NOT empty

    Hi,

    How do i create a msgbox in outlook that prompts me before sending an email if the TO and or CC fields are NOT empty. i mostly send using the BCC field.. can anyone help?

    Thank you.

  2. #2
    Sub CheckToAndCcFieldsAndSend()
    
    ' Add Reference to "Microsoft Forms 2.0 Object Library"
    ' If not available, find it by browsing to "c:\Windows\SysWOW64\FM20.DLL"
    
        Set myItem = ActiveInspector.CurrentItem
        
        If myItem.CC = "" And myItem.To = "" Then
            MsgBox "OK"
            myItem.Send
    
        Else
            MsgBox "Get rid of To and/or CC field!"
        End If
    End Sub
    Last edited by acantor; 04-01-2014 at 02:59 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •