+ Reply to Thread
Results 1 to 5 of 5

VBA code to search strings in mail subject, body and drop in folders

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    3

    Post VBA code to search strings in mail subject, body and drop in folders

    Dear Experts,
    Can anyone help me on the following,

    I have 5 to 6 folders in my mail box. The incoming mail to be sorted based on certain strings in the mail subject, mail body and also on a string from the sender email id

    Can anybody help pl.

    Thanks

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,052

    Re: VBA code to search strings in mail subject, body and drop in folders

    You don't need VBA for this. You can set up filter rules in Outlook. You can sort mail to existing folders based on key words in the subject or sender's name or even if it has an attachment.

    I have more than a dozen rules set up and they all work well.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    3

    Re: VBA code to search strings in mail subject, body and drop in folders

    Thanks for your reply dflak. I need to search certain words which, if upper case like "WR" should identify and put in a folder. If "wr" lower case is detected, then, it should not perform the action. I would like to know, if the filter rule is specific to the cases (upper, lower)

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,052

    Re: VBA code to search strings in mail subject, body and drop in folders

    I don't know if they are. Set up an experiment: Make a filter rule for an uppercase and another one for a lower case subject and send yourself a couple of emails .

    I'm curious about the results.
    Last edited by dflak; 07-12-2018 at 09:22 AM.

  5. #5
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    3

    Re: VBA code to search strings in mail subject, body and drop in folders

    Hello dflak, I had tried this without any success. Hence I thought may a vb code is required to be generated

+ 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. [SOLVED] How to add mail addresses, Subject and body from excel to outlook
    By zaska in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2016, 04:08 PM
  2. I want to open up an outlook e-mail with info. pre-set in the subject and body...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 10:47 AM
  3. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  4. [SOLVED] Excel can send mail with multiple cells info as email body and subject, befr 3 day of due
    By ExcelUser2707 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2013, 06:49 AM
  5. [SOLVED] Excel can send mail with multiple cells info as email body and subject, befr 3 day of due
    By ExcelUser2707 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2013, 04:29 AM
  6. Fill 'Subject' and Body of an e-mail
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-15-2011, 08:14 AM
  7. want to mail workbook to addresses in range, subject and body in cells
    By arunjoshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2005, 12:01 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