Consulting

Results 1 to 4 of 4

Thread: Outlook Rules Question

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Lightbulb Outlook Rules Question

    Hi, I am currently using InStr to look for a String in another String

    findRefund = InStr(1, "Refund order - Item code 10000000", "Refund", vbTextCompare)
    But what if I want to use multiple search criteria, with capitalization variants?

    E.g.

    Refund
    refund
    Exchange
    exchange
    Return
    return
    Writing separate InStr lines for each criteria seems inefficient.

    How do you search for all of these criteria using minimal code?
    Last edited by Cheesecube; 04-28-2020 at 10:16 PM. Reason: Changed question to how to search for multiple criteria instead

Tags for this Thread

Posting Permissions

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