+ Reply to Thread
Results 1 to 6 of 6

Outlook script to forward emails based on senders' address

  1. #1
    Registered User
    Join Date
    02-03-2016
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Outlook script to forward emails based on senders' address

    Hello,

    I desperately need help for this. My office inbox receives 100-200 emails daily which we have to disseminate to different groups of people in the firm. I was hoping to semi-automate this process by forwarding each incoming email based on the senders' address to the corresponding group of recipients. For example, if the senders' address contains "@oaktree.com", then this email should be forwarded to a group of people handling the Oaktree account.

    Typically, if we only had a few accounts, I can upload each account one by one. However, we have 1000+ accounts to be forwarded and I cannot possibly upload them account by account. Each senders' address is also accompanied by a group of recipients and these are all recorded in an excel sheet.

    Is there anyway for the script to search the senders' address in the incoming email, and then forward it to the relevant account handlers stated in the excel sheet?

    Thanks so much so much in advance.

    Best regards,
    Project_paw
    Last edited by Project_paw; 02-03-2016 at 11:15 AM.

  2. #2
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: Outlook script to forward emails based on senders' address

    That's exactly what 'Rules' in Outlook are for... 'Home' tab/'Move' Group/'Rules' button.

  3. #3
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: Outlook script to forward emails based on senders' address

    Mouse bounce (Again)

  4. #4
    Registered User
    Join Date
    02-03-2016
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Re: Outlook script to forward emails based on senders' address

    ------------------------------
    Last edited by Project_paw; 02-03-2016 at 11:29 AM.

  5. #5
    Registered User
    Join Date
    02-03-2016
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    3

    Re: Outlook script to forward emails based on senders' address

    Hi grimes0332, I can use the rules, but that will mean i need to manually create 1000+ rules because I have 1000+ accounts. Is there anyway to for outlook to base the condition on the list of senders stated in an excel sheet and then forward the emails to the corresponding account handlers?

    Thanks,
    Project_paw

  6. #6
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: Outlook script to forward emails based on senders' address

    Sorry, I misunderstood. That might be a little more complicated.

    It can be done in Excel but you need to think how it's approached. For example, you can move messages individually when they arrive but that will only work while the workbook is open. The other approach would be to scan the InBox occasionally.

+ 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. Forward Email Based on Selected Object's Subject and/or Sender and Recipient Address
    By Citanaf in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2015, 07:38 PM
  2. Use VBA to send email from Outlook and use senders default signature
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-21-2015, 11:02 AM
  3. [SOLVED] Extract Senders Email Address
    By Rustyroof in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2015, 08:36 AM
  4. 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
  5. [SOLVED] How to forward or redirect an outlook email based on count one at a time to one user
    By anchuri_chaitanya in forum Outlook Programming / VBA / Macros
    Replies: 11
    Last Post: 08-25-2011, 01:18 PM
  6. Code to deleted all emails from pre-defined senders
    By Jim28 in forum Outlook Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2011, 06:25 PM
  7. Replies: 0
    Last Post: 06-04-2005, 05:05 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