Hello, and apologies if this has been asked before but my searches have so far proved fruitless.
I create approx. 500 Excel and Word documents every week for various recipients throughout the company that I work for. One of the head honchos has asked to be cc'd on all of these for this week only to determine the worth of continuing this way.
The documents are all created via an MS Access Database and VBA scripts to send the individual reports via Outlook. Initially, I was going to add my boss as a recipient on every single one - simple but time consuming. Then I had the idea of creating a Rule in Outlook to automatically send a copy of every outgoing email to her. Set it up in no time and a couple of tests worked perfectly.
Unfortunately, the rule does not seem to be working on the emails being created outside of the outlook environment i.e. the VBA scripting from Access. Even trying to run the rule manually over the Sent Items box does not work.
As I'm writing this, I've just remembered that we have the little program that "avoids" the pop-up security message when trying to send emails via VBA - would this be impacting the Rules in any way? And if not, does anyone know what else would be preventing the rule from working?
Any help would be greatly appreciated - even just confirmation that it can't be done this way.
Many Thanks
Tracey L
Brisbane, Aus
I create approx. 500 Excel and Word documents every week for various recipients throughout the company that I work for. One of the head honchos has asked to be cc'd on all of these for this week only to determine the worth of continuing this way.
The documents are all created via an MS Access Database and VBA scripts to send the individual reports via Outlook. Initially, I was going to add my boss as a recipient on every single one - simple but time consuming. Then I had the idea of creating a Rule in Outlook to automatically send a copy of every outgoing email to her. Set it up in no time and a couple of tests worked perfectly.
Unfortunately, the rule does not seem to be working on the emails being created outside of the outlook environment i.e. the VBA scripting from Access. Even trying to run the rule manually over the Sent Items box does not work.
As I'm writing this, I've just remembered that we have the little program that "avoids" the pop-up security message when trying to send emails via VBA - would this be impacting the Rules in any way? And if not, does anyone know what else would be preventing the rule from working?
Any help would be greatly appreciated - even just confirmation that it can't be done this way.
Many Thanks
Tracey L
Brisbane, Aus