+ Reply to Thread
Results 1 to 8 of 8

Selectin emails in Outlook

  1. #1
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Selectin emails in Outlook

    Hi,

    I'd like to ask you for help since I need to use the vba code in order to select (and do nothing else) all emails that are located in my Inbox in Outook and were received today. - it will be for generated reports each day that's why it is crucial to select only emails on that specific day.

    Do you have any solution?

    Thank you in advance.

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Selectin emails in Outlook

    Hi
    this seems to work though it may be a bit slow if your inbox contains lots of emails

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Re: Selectin emails in Outlook

    Hi,

    thank you for the answer. Unfourtunatley it does not work for me in any way. Nothing happens in my mailbox.

    Could you indicate what to do to fix this?

  4. #4
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Selectin emails in Outlook

    Hi
    the macro assumes that the emails to select are in your default inbox and this is the active view in Outlook. If this isn't the case the macro may not work

  5. #5
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Re: Selectin emails in Outlook

    I must have done something wrong in the first place. It does work now. Thank you for your help

  6. #6
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Selectin emails in Outlook

    you're welcome. I'm glad it worked.

  7. #7
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Re: Selectin emails in Outlook

    Hi!

    I just wanted to change the code a little bit and instead of today's date I want to choose yesterday's. So I thought to create DAte - 1 but not working

    Please Login or Register  to view this content.
    Could you please let me know as well how to change it accordingly?

    Also when I have selected for example a may from a week while macro is running it does select emails from today but also the one that was selected before macro is activated. Is there a way to unselct that email then?

    Many thanks in advance.
    Last edited by Szwadron6; 07-18-2017 at 05:14 AM.

  8. #8
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Selectin emails in Outlook

    Hi
    the received time property is a number comprising both date and time, so changing the formula from "greater than" to "equals" will only capture emails sent at precisely midnight. Try this instead:

    Please Login or Register  to view this content.

+ 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] Excel VBA Outlook needing to add to and CC to outlook emails
    By flevojax in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2018, 01:04 PM
  2. Outlook 2010, send all emails from outlook outbox
    By joao1232 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-22-2016, 07:33 PM
  3. Track Outlook Emails - sent emails in Excel
    By baluraipur in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2015, 09:18 AM
  4. Automatic Emails using outlook
    By behnam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2013, 09:51 AM
  5. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  6. Send outlook emails with message in cells to individual emails associated with them
    By abinayan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 06:11 AM
  7. How can i backup my Outlook Emails
    By joe41 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2009, 05:11 AM

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