Macro to run Rules in batch

bman342 · External Since: Apr 08, 2006 Posts: 20

I have about 40+ newsletters I subscribe to. I have set up Rules for them in
Outlook, so that they are automatically moved from my Inbox to their
respective folder when they arrive.

What I'd like to be able to do: Turn the Rules off, so the newsletters stay
in my inbox. Then turn the Rules back on when I choose, and automatically
have all the newsletters filed in their respective folders. The only way to
do this now, is to go into each Rule individually, and execute it.

Unfortunately there is no recordable macros for Outlook, which for me would
be the easiest.

Anyone have some VBA code that I could customize for what I am trying to do?
Thanks.

Sue Mosher [MVP-Outlook] · External Since: Feb 11, 2005 Posts: 21627

Rules can be run programmatically only in Outlook 2007. Is that what you have?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"bman342" wrote in message
>I have about 40+ newsletters I subscribe to. I have set up Rules for them in
> Outlook, so that they are automatically moved from my Inbox to their
> respective folder when they arrive.
>
> What I'd like to be able to do: Turn the Rules off, so the newsletters stay
> in my inbox. Then turn the Rules back on when I choose, and automatically
> have all the newsletters filed in their respective folders. The only way to
> do this now, is to go into each Rule individually, and execute it.
>
> Unfortunately there is no recordable macros for Outlook, which for me would
> be the easiest.
>
> Anyone have some VBA code that I could customize for what I am trying to do?
> Thanks.

bman342 · External Since: Apr 08, 2006 Posts: 20

Sue:

No, I've got '03. Guess I am SOL until I upgrade. And even then I need to
track down some code.

Thanks,

-b

"Sue Mosher [MVP-Outlook]" wrote:

> Rules can be run programmatically only in Outlook 2007. Is that what you have?
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
> "bman342" wrote in message
> >I have about 40+ newsletters I subscribe to. I have set up Rules for them in
> > Outlook, so that they are automatically moved from my Inbox to their
> > respective folder when they arrive.
> >
> > What I'd like to be able to do: Turn the Rules off, so the newsletters stay
> > in my inbox. Then turn the Rules back on when I choose, and automatically
> > have all the newsletters filed in their respective folders. The only way to
> > do this now, is to go into each Rule individually, and execute it.
> >
> > Unfortunately there is no recordable macros for Outlook, which for me would
> > be the easiest.
> >
> > Anyone have some VBA code that I could customize for what I am trying to do?
> > Thanks.
>

Sue Mosher [MVP-Outlook] · External Since: Feb 11, 2005 Posts: 21627

The code for Outlook 2007 is well documented, both in Help and in a sample at http://www.outlookcode.com/codedetail.aspx?id=1266

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"bman342" wrote in message
> Sue:
>
> No, I've got '03. Guess I am SOL until I upgrade. And even then I need to
> track down some code.
>
> Thanks,
>
> -b
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> Rules can be run programmatically only in Outlook 2007. Is that what you have?
>>
>> "bman342" wrote in message
>> >I have about 40+ newsletters I subscribe to. I have set up Rules for them in
>> > Outlook, so that they are automatically moved from my Inbox to their
>> > respective folder when they arrive.
>> >
>> > What I'd like to be able to do: Turn the Rules off, so the newsletters stay
>> > in my inbox. Then turn the Rules back on when I choose, and automatically
>> > have all the newsletters filed in their respective folders. The only way to
>> > do this now, is to go into each Rule individually, and execute it.
>> >
>> > Unfortunately there is no recordable macros for Outlook, which for me would
>> > be the easiest.
>> >
>> > Anyone have some VBA code that I could customize for what I am trying to do?
>> > Thanks.
>>

Indian Idol · External Since: Mar 14, 2007 Posts: 1

I tried to create a custom action in outlook 2003 and it worked for me. You
may
use the help link to find details on how to do this.
http://support.microsoft.com/kb/292063/EN-US/

I hope this will help you.

"Sue Mosher [MVP-Outlook]" wrote:

> The code for Outlook 2007 is well documented, both in Help and in a sample at http://www.outlookcode.com/codedetail.aspx?id=1266
>
> --
> Sue Mosher, Outlook MVP
> Author of Configuring Microsoft Outlook 2003
> http://www.turtleflock.com/olconfig/index.htm
> and Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
> "bman342" wrote in message
> > Sue:
> >
> > No, I've got '03. Guess I am SOL until I upgrade. And even then I need to
> > track down some code.
> >
> > Thanks,
> >
> > -b
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> Rules can be run programmatically only in Outlook 2007. Is that what you have?
> >>
> >> "bman342" wrote in message
> >> >I have about 40+ newsletters I subscribe to. I have set up Rules for them in
> >> > Outlook, so that they are automatically moved from my Inbox to their
> >> > respective folder when they arrive.
> >> >
> >> > What I'd like to be able to do: Turn the Rules off, so the newsletters stay
> >> > in my inbox. Then turn the Rules back on when I choose, and automatically
> >> > have all the newsletters filed in their respective folders. The only way to
> >> > do this now, is to go into each Rule individually, and execute it.
> >> >
> >> > Unfortunately there is no recordable macros for Outlook, which for me would
> >> > be the easiest.
> >> >
> >> > Anyone have some VBA code that I could customize for what I am trying to do?
> >> > Thanks.
> >>
>