How to prevent sending attachments to CC and BCC recipients when composing email in Outlook?
As we all known, all recipients in “To”, “CC” or “BCC” fields, will get the attachments when sending emails with attachments. However, some users want to send the attachments to the “To” recipients only, with the “CC” and “BCC” recipients just getting the message without the attachments. How could you solve this job in Outlook?
In fact, Outlook does not offer an option for dealing with this task, but, the following VBA code can do you a favor, please do as this:
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, double click ThisOutlookSession from the Project1(VbaProject.OTM) pane to open the mode, and then copy and paste the following code into the blank module.
VBA code: Prevent sending attachments to CC and BCC recipients:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim xMailItem As Outlook.MailItem Dim xNewMail As Outlook.MailItem If Item.Class <> olMail Then Exit Sub Set xMailItem = Item Set xNewMail = Outlook.Application.CreateItem(olMailItem) With xNewMail .CC = xMailItem.CC .BCC = xMailItem.BCC .Subject = xMailItem.Subject .HTMLBody = xMailItem.HTMLBody .Send End With xMailItem.CC = "" xMailItem.BCC = "" End Sub
3. Then save and close the code window.
4. From now on, when sending an email with attachments, only the recipients in To field can receive the attachments, and the recipients in CC and BCC can only get the message without attachments.
Recommended Productivity Tools
- Complicated and repeated operations can be done a one-time processing in seconds.
- Forward multiple emails individually with one-click, and auto forward by rules.
- Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
- Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
- 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.