+ Reply to Thread
Results 1 to 2 of 2

Time Delayed Pause Break

  1. #1
    Registered User
    Join Date
    03-13-2009
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    98

    Time Delayed Pause Break

    I have a VBA code which displays Text from emails by looking at various folders in Outlook. I would like to have a Delayed Pause before it moves onto the next folder. Is it possible to create a Delayed Pause Break. The Delayed Pause should fit in 'PAUSE' as below:

    or j = 1 To mailBox.Folders.Count
    If (mailBox.Folders(j) = Sheet1.Cells(folderIndex, 1).Value) Then

    Set actionFolder = mailBox.Folders(j)

    For Each Item In actionFolder.Items
    If (Item.UnRead) Then
    Dim subjectSplit As Variant

    subjectSplit = Split(Item.Subject)
    Sheet1.Cells(folderIndex, 2) = subjectSplit(2)
    Sheet1.Cells(folderIndex, 3) = subjectSplit(3)
    Item.UnRead = False
    End If
    Next Item

    'PAUSE'
    End If
    Next j

  2. #2
    Registered User
    Join Date
    06-01-2010
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Time Delayed Pause Break

    I know for a fact there's an easier way... but this will work if you want it to pause for a specific amount of time.
    Please Login or Register  to view this content.
    where time is the delay in seconds.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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