+ Reply to Thread
Results 1 to 2 of 2

Excel Macro to Create Folders and Rules on Outlook

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Rio, Brazil
    MS-Off Ver
    2010
    Posts
    1

    Excel Macro to Create Folders and Rules on Outlook

    Hi Guys,

    I needed your support so solve the following situation.

    A macro to: (1) Create a folder on Outlook 2010 and then (2) Create a Rule that every email with ### on the subject goes to that folder created on rule 1.

    I could manage to do that on Outlook VBA... but how to share that rule with a group of 20 people arround the world? (they don't know nothing about macros.. so import the OTM and run the macros from there would not be the best option - The VBA Code is below for your reference)

    The ideal solution would be a Excel spreadsheet that they could open and hit two buttons with the rules above (or one button with both rules).

    Can you guys help with this?


    VBA CODE:

    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Excel Macro to Create Folders and Rules on Outlook

    Looks like it is mostly done.

    If you call CreateRule just before closing the workbook you can use one button.

    Reference Outlook in CreateRule as Application by itself would be Excel.

    Please Login or Register  to view this content.
    To mark "Solved" go to Thread Tools.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create Outlook Reminder on Excel and transfered to outlook by macro
    By Benjamin2008 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2013, 03:23 PM
  2. Auto Create multiple folders within an Outlook Subfolder using Excel List
    By lawriecunningham in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2013, 05:02 PM
  3. [SOLVED] Outlook 2010 - Creating Rules - Rules Constant
    By Jack7774 in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 03-18-2013, 03:48 PM
  4. code to create folders in outlook from excel
    By ronilei in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2012, 09:13 PM
  5. Excel Macro to download attachments from multiple sub folders of outlook
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2010, 09:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1