AutoArchive | Continous Integration library

I have a C# / .NET Windows service that is archiving Exchange mailboxes, and I recently "packaged" the Veeam O365 Backup DLLs to be able to backup Exchange Online mailboxes automatically.

I 'll show you some piece of log showing that the program runs without issue for a while, then starts to fail out of nowhere with the error:

• "Could not load file or assembly 'System.IO.Compression, Version=4.2.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference."

... until the service is restarted:

(see Edit1, my picture got overwritten)

The stacktrace:

Does anyone know a script that would let me copy data from cells A3:E1000 on Sheet1 and paste it to Sheet2. After pasting I need it to delete the exact data that it copied from Sheet1 (Sheet2 will still have copied data) and I need it to do this everyday at 11:30pm. I need Sheet2 to be able to keep taking the data forever as a digital archive of the data that is being copied daily from Sheet1. I hope this makes sense. I can't figure it out. When I run this it works if I run dailyLog and then run clearRange separately. When I run autoArchive it deletes the data from Info sheet but doesn't paste it into the Archive sheet.

I'm trying to make an automated archiving script for my G Suite mailbox.

The script contains a search query which then should take all found results, remove from inbox and add a custom label (archive) to it.

I'm struggling with the addLabel part. It throws an error InternalError: Cannot find method addLabel(string). but when I check the documentation it seems to be the right method on the right object.

Any help would be appreciated.

Auto-gmail archiving

This question looks like it should have been answered here: Outlook VBA Save Copy Sent Item

I am unable to find the referenced "Items.ItemAdd" event amongst the list of events in the VB Editor for Outlook 2016.

Application.ItemSend is located in "ThisOutLookSession". The script I came up with looks 90% similar to the one posted in the original question and I have the same problem. The mail item is saved in it's pre-send condition.

I can't use "MailItem.SaveSentMessageFolder" as I am trying to move the sent mail to a PST.

The Event is explained here: https://msdn.microsoft.com/en-us/vba/outlook-vba/articles/items-itemadd-event-outlook

In case someone asks "Why not use the AutoArchive Function?", my organization has some terrible group policies set up for both Sent Items and AutoArchive. I can't wade through the mess to get AutoArchive for sent items set up.

I have an issue where I need to permanently delete emails from a shared mailbox that are older than a certain age.

Unfortunately, the AutoArchive function does not affect the shared mailbox, and every time I try to run a rule to do this, it fails and does not take any action. I've been having to manually clear hundreds of emails from this mailbox which takes an absolute age (when you have over 300k sitting in there...), as it fills up my own deleted items when I do.

I am very well versed in Excel VBA but I have no clue how Outlook likes to handle things. I've been searching for a way to do this but I have yet to find anything reliable that I can use that is well annotated to teach me.

Has anybody else ever had to do the same thing? I can't be the only one who wants to do this?

Edit: I've been chopping up random bits of code I've found to try and achieve this. I have access to 6 other shared mailboxes within my department. I've been looking at the GetSharedDefaultFolder function but it is not very well explained and normally errors when my bodged attempt runs. I am not sure what it wants in the recipient function, as I have tried the mailbox name and address. The MS online resources aren't very helpful in this case:

Edit 2:

I have edited my code to the below. In this version I get an Overflow error on the line For intCount = olSharedBox.Items.Count To 1 Step -1 Since there are over 300k emails in that box I think it is now looking at the right thing but not sure of a way around it. Is it not possible to get the current number from the pre-counted figure that appears next to the inbox?