1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MS Outlook - find subject line by VBA (in excel)

Discussion in 'VBA Macros' started by Akshay Divecha, Mar 8, 2018.

  1. Akshay Divecha

    Akshay Divecha New Member

    Messages:
    7
    Hi Experts,

    I need help regarding Outlook VBA.

    I have subject lines mentioned in an excel file, for example Range A3, A4,A5,A6

    I need to check in Outlook 2016, Inbox if mail with subject line mentioned in
    Column A is received or not.

    If received, then details such as senders address, subject line, received date to be copied in column B, C & D

    Also the hyperlink of the email to be created on column E

    Can anyone please share the codes

    Thanks in advance...

    Attached Files:

  2. Belleke

    Belleke Active Member

    Messages:
    481
    Hi,
    Hope this helps.
    No need to open outlook but when outlook is open the code is faster.
    See attached
    Mails received less or equal to 6 days will appear in the results, change to your needs.

    Attached Files:

    Akshay Divecha likes this.
  3. Akshay Divecha

    Akshay Divecha New Member

    Messages:
    7
    Hi Belleke,

    Thanks for your work, got the error msg as attached.

    any possibility to find the emails within a range of 1 month.

    Also if i can add subject directly in column B instead of adding it from "Add Subject"

    Also if subjects are deleted from column B, it does not gets deleted from "Find" button.

    Please help !

    Once again thanks.

    Attached Files:

  4. Belleke

    Belleke Active Member

    Messages:
    481
    See attached (2)
    The first example
    Add or delete subjects in column B, push the renew button to reload the combobox
    The second example, click a subject in Column B and push the search button
    IMPORTANT!! I forgot to mention yesterday.:oops:
    In the VBA editor you have to check Microsoft Outlook 16.0 Object Library
    in Extra -> References

    Attached Files:

  5. Akshay Divecha

    Akshay Divecha New Member

    Messages:
    7
    Thanks once again Belleke,

    But there are some errors which need your help to fix.

    Seems all mails are fetched instead of desired mail.

    Hyper link is also not working.
  6. Akshay Divecha

    Akshay Divecha New Member

    Messages:
    7
    Dear Exports / Belleke, please help on this one...
  7. Akshay Divecha

    Akshay Divecha New Member

    Messages:
    7
    Dear Experts,

    Need your help..

Share This Page