May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) 'comments 'This version is suitable for Outlook 2003 or later. It uses Outlook objects exclusively and 'includes error handling to avoid problems with an invalid Bcc address. 'Place this VBA code in the built-in ThisOutlookSession module 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 = "firstname.lastname@example.org" Set objRecip = Item.Recipients.Add(strBcc) objRecip.Type = olBCC strBcc = "email@example.com" 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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Exchange password change on mobile||2||106|
|Need help creating a nested folder using MS Access and the Outlook Object Module||3||49|
|Export email data from Google to PST files||8||72|
Join the community of 500,000 technology professionals and ask your questions.