Created
August 14, 2013 11:31
-
-
Save sooop/6230210 to your computer and use it in GitHub Desktop.
Auto Bcc Visual Basic Macro
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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