+ Reply to Thread
Results 1 to 5 of 5

Outlook Rules

  1. #1
    Forum Contributor
    Join Date
    05-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    184

    Outlook Rules

    We have three people in our department. Person "A" handles employees with last name from A - L , Person "B" handles employees with last name from M - Q, and person "C" handles employees with last name from R-Z. Is there a way to set a rule in outlook so that as e-mail comes into our inbox, it checks the last name and move it to a specific folders?

    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,677

    Re: Outlook Rules

    Outlook rules are not that sophisticated. It can go by strings found in the sender's address, but not by first letter.

    I think this could be done with a macro (not sure) but your description needs some clarification.

    The way you described this is as if the emails are arriving at a single email address and you want to move them to subfolders under the InBox. However, you also said this there are three different people. How will those three people access the subfolders? Is this a shared email account?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    05-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    184

    Re: Outlook Rules

    Yes, it's a shared alias. We are payroll accountants, and all three of us monitor the same alias ([email protected]). Is it possible to do that?

  4. #4
    Registered User
    Join Date
    07-25-2016
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    1

    Re: Outlook Rules

    Select File | Manage Rules & Alerts.
    Click on the New Rule button.
    Locate the "Step 1: Select a template" box.
    Under the section labeled "Start from a blank rule", select Apply rule on messages I receive.
    Click Next.
    In the "Which condition(s) do you want to check?" box,check the box with specific words in the subject.
    In the "Edit the Rule Description" box below, click on specific words.
    In the "Specify words or phrases to search for in this subject" window, type the text to sear for. In this example, you would type [earth-info].
    Click the Add button. Click OK. Click Next.
    Check the box to the left of the action you wish to perform on this message. In this example, you would check the box to the left of move it to a specified folder.
    In the "Edit the Rule Description" box below, click on specified.
    In the "Choose a folder" dialog box, select an already existing folder or create a new one.
    Click Next at the "Are there any exceptions?" box.
    Specify a name for this filter. It does not matter what you call it. This is just so you can tell it apart from other filters you may create. Make certain that the box to the left of Turn on this rule is checked.
    Click Finish | OK.
    [commercial links removed by Moderator]
    Last edited by 6StringJazzer; 07-25-2016 at 07:35 AM.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,677

    Re: Outlook Rules

    sofiarose123, your response is related to the question but is not responsive to it. The question specifically asks about first letter of last name of sender, and you gave a general Help page description of how to add a rule. It appears that this was just so you could also post a couple of links to a completely unrelated commercial site.

    If you do this again you will be banned for spam.

+ 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. Sending e-mails based on tiered rules from Excel via Outlook
    By FlaideyGhand in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-11-2015, 11:52 AM
  2. Outlook Rules - moving emails from a sender in a specific address book
    By UKRyan in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-22-2014, 11:12 AM
  3. Excel Macro to Create Folders and Rules on Outlook
    By luiz.fellipe in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 09-15-2014, 04:09 PM
  4. conditional formatting rules for a cell on sheet 1 based on rules from sheet 2
    By jsard in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-15-2013, 09:22 AM
  5. [SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:25 PM
  6. [SOLVED] Outlook 2010 - Creating Rules - Rules Constant
    By Jack7774 in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 03-18-2013, 03:48 PM
  7. Outlook 2010 Rules to categorize and move
    By TreeFittyZ in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 06-27-2012, 07:02 PM

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