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
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":
I have no idea what I'm doing so any help would be greatly appreciated!