+ Reply to Thread
Results 1 to 4 of 4

VBA to search an Outlook 2010 mail in Sent Items from Excel

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    62

    Post VBA to search an Outlook 2010 mail in Sent Items from Excel

    Hello,

    Need help, I am new to VBA.

    I need an Excel VBA to search an Outlook 2010 mail in Sent Items, sent on current date with subject as "Task Completed", if found the mail then open an excel file.

    Sometimes Subject may have an additional text like Task Completed on 07/01/2017 or Task Completed 01/09/2017

    I am using Outlook 2010, Win 7.


    All your help will be much appreciated.

    Thank you in advance
    Pradeep M

  2. #2
    Registered User
    Join Date
    02-02-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    62

    Re: VBA to search an Outlook 2010 mail in Sent Items from Excel

    Guys,

    Please help me on this.

  3. #3
    Registered User
    Join Date
    02-02-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    62

    Re: VBA to search an Outlook 2010 mail in Sent Items from Excel

    Hi,

    Unfortunately I didn't get any response from the Excel Forum members, but I got the code from other forum and I am posting it here if somebody needs and to close this thread.

    Please Login or Register  to view this content.
    Thank You,
    Pradeep

  4. #4
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: VBA to search an Outlook 2010 mail in Sent Items from Excel

    Hi man,

    please can you post and the Log_Mail macro?

    Thank you machan,
    Ionut
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

+ 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. General: attach file in Outlook 2010 mass mail merge
    By Karnik in forum Excel General
    Replies: 3
    Last Post: 04-15-2016, 08:04 PM
  2. get mail items in outlook
    By trioxygin in forum Excel General
    Replies: 1
    Last Post: 05-29-2015, 11:42 AM
  3. Mail using VBA with the picture displaying in email body in MS outlook 2010
    By venikumar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2015, 06:45 AM
  4. Excel VBA to delete sent mail from outlook 2010
    By kokjinq in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2015, 08:53 PM
  5. [SOLVED] Mail merge from Excel to outlook 2010 -reg
    By sbabu16 in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 01-28-2014, 07:19 PM
  6. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  7. Need to Copy Outlook 2010 Mail message to Excel 2010
    By pradeepdeepu_001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2012, 11:35 PM

Tags for this Thread

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