+ Reply to Thread
Results 1 to 2 of 2

Searching emails for list items

  1. #1
    Forum Contributor
    Join Date
    Lubbock, TX, USA
    MS-Off Ver

    Searching emails for list items

    Is there a way to search the bodies of emails for items in a list? I know I can search for a string via the provided search bar. And, that is usually ok. But, I received a list of sixty serial numbers and doing them one at a time is going to be tedious.

  2. #2
    Forum Contributor Dante Amor's Avatar
    Join Date
    MS-Off Ver
    Excel 2013

    Re: Searching emails for list items

    Please check the following solution, extract the mail body and put it into excel. There you could already apply some filter.


    Or in this line you can look for the serial numbers:
    Cells(f, "C") = MyItems(n).body
    Regards Dante Amor

+ 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] Extract and return a distinct and duplicate items list separately from a two list items
    By Mohammad Munawar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-14-2020, 07:42 AM
  2. need a macro that will send an email or emails from a list of emails
    By MassiveJim in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-08-2020, 11:09 PM
  3. [SOLVED] Searching through worksheet for a list of items
    By Brandon2013 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-13-2019, 12:17 PM
  4. Replies: 1
    Last Post: 06-08-2017, 11:30 AM
  5. Extract Inbox/Sent Items emails addresses from following fields: FROM, TO, CC, BCC
    By ana.ciofrangeanu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2014, 08:00 AM
  6. Replies: 4
    Last Post: 07-26-2012, 11:31 AM
  7. 2 Queries (Searching and emails)
    By realwillow in forum Excel General
    Replies: 3
    Last Post: 09-24-2008, 10:55 PM


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