Skip to content

Instantly share code, notes, and snippets.

@sooop
Created August 14, 2013 11:31
Show Gist options
  • Save sooop/6230210 to your computer and use it in GitHub Desktop.
Save sooop/6230210 to your computer and use it in GitHub Desktop.
Auto Bcc Visual Basic Macro
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim objRecip As Recipient
Dim strMsg As String
Dim res As Integer
Dim strBcc As String
On Error Resume Next
' #### USER OPTIONS ####
' address for Bcc -- must be SMTP address or resolvable
' to a name in the address book
strBcc = "[email protected]"
Set objRecip = Item.Recipients.Add(strBcc)
objRecip.Type = olBCC
If Not objRecip.Resolve Then
strMsg = "Could not resolve the Bcc recipient. " & _
"Do you want still to send the message?"
res = MsgBox(strMsg, vbYesNo + vbDefaultButton1, _
"Could Not Resolve Bcc Recipient")
If res = vbNo Then
Cancel = True
End If
End If
Set objRecip = Nothing
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment