printsnsa.blogg.se

You will need macro security set to low during testing. StrBcc = Use the account name as it appears in Account Settings

To BCC from all but one account, replace the = sign in the If statement with. Be sure to use the account name as it appears in the From field or Account Settings dialog. If you have multiple accounts in your profile and only want to BCC messages sent through a specific account, use an IF statement to check the SendUsingAccount value. Set objRecip = (strBcc)īCC Messages sent From a Specific Account StrBcc = Item.Categories = "Important" Then Get the code from Adding Categories when Composing Email. You could also use a macro to add a specific category to the ribbon for easy access. To add a category to email, click on the Expander in the Tags group and choose the Category from the options dialog. It could easily be switched around to exit if there is a category and BCC everything else. This code block BCCs one address if the category is Personal, another if the category is Important and exits if there is no category. While you can filter on To, subject, or category fields, if you need to use series of If statements, filtering by category may be the easiest. If you need to BCC, some but not all, messages, you'll need to use an IF statement to filter the messages. Res = MsgBox(strMsg, vbYesNo + vbDefaultButton1, _ StrMsg = "Could not resolve the Bcc recipient. ' or resolvable to a name in the address book Private Sub Application_ItemSend(ByVal Item As Object, _ Basic VBA instructions are below, instructions with screenshots are at How to use Outlook's VBA Editor.