+ Reply to Thread
Results 1 to 2 of 2

VBA to resend every email in an Outlook folder

  1. #1
    Forum Contributor
    Join Date
    07-17-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel for O365
    Posts
    197

    VBA to resend every email in an Outlook folder

    Good afternoon all, not sure if this is allowed as it's pertaining to VBA in Outlook rather than Excel - I just haven't found a more engaging and active community than the Excel one.

    I've had a problem passed to me that I think can be solved with VBA...

    I have an Outlook inbox containing nearly 30,000 undeliverable messages that needs to be sent again. To create an audit trail, I'm told.

    The process is simple so I'm hoping it's simple to replicate in VBA?:
    • For each email in "Inbox"
    • Open the first failure email
    • Press "send again"
    • This opens the original email in a new window, leave the email untouched, and click “Send”
    • Close the failure email
    • Move failure email to the "Archive" folder
    • Repeat

    Initial discussions were about doing this manually until I pointed out that even at only 10 seconds per email, it would take 80+ hours.

    I understand doing it with VBA will still take some time? - But I can at least just set a laptop up and run the macro so it's not a person doing it which would be soul destroying.

    I have some limited experience with VBA in Excel but next to none in relation to Outlook.

    From some Google-fu, I've got as far as the below but I get a compile error, "For without next":

    Please Login or Register  to view this content.
    I have no idea what I'm doing so any help would be greatly appreciated!

  2. #2
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    896

    Re: VBA to resend every email in an Outlook folder

    You have 2 For Each loops, but only 1 Next
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

+ 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] VBA save document as PDF in folder and attached to an outlook email
    By Danny1986 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-19-2020, 10:38 AM
  2. Move read email to another folder in outlook
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2017, 05:22 AM
  3. Need VBA macro to copy last sent outlook email on specified folder
    By Nanimadhu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2014, 11:09 AM
  4. Dowload outlook email attachment to my pc folder using Excel VBA
    By din.malay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 08:06 AM
  5. Dowload outlook email attachment to my pc folder
    By din.malay in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 12-11-2013, 03:34 AM
  6. Move an email to a folder in outlook using macro
    By Arunkumark in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 07-11-2013, 09:33 AM
  7. Resend email
    By MartinF in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2013, 03:53 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