Find Jobs
Hire Freelancers

Outlook VBA - custom archiving app

$750-1500 AUD

Stengt
Lagt ut nesten 3 år siden

$750-1500 AUD

Betalt ved levering
I have a customer with a bloated Office 365 mailbox. They use the calendar of this mailbox for scheduling their training courses, which wouldn't normally be a problem, but after a course completes, they then load up the calendar item with documents, PDFs, etc. pertaining to the course and its' participants. They are constantly opening and changing historical calendar events. So here's the tricky part. Outlook's built-in archiving function archives calendar items based on the "last changed date", not appointment beginning or end date, so the results would be highly unpredictable. What I'm looking for is someone that can twist up a VBA app that will step through O365 mailbox calendar items, and move them to a .PST based on event start date. I have been a VB/VBA developer for many years, Word and Excel VBA is dead simple, but Outlook looks like a different kettle of fish. I never worked with Outlook, and I don't have time for the learning curve. They are about to hit their quota. This seems like it would be a fairly straightforward task for someone familiar with Outlook VBA. VBA script to run on one PC, against an O365 mailbox. Prompt for PST filename, and archive date. Create PST file, and process calendar items based on event start date, moving entries prior to specified date to new PST file, and removing the original entry from the mailbox. Ability to run in non-destructive "test mode".
Prosjekt-ID: 30493343

Om prosjektet

5 forslag
Eksternt prosjekt
Aktiv 3 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
5 frilansere byr i gjennomsnitt $1 140 AUD for denne jobben
Brukeravatar
Hello, In order you could have an access to Outlook 365 externally, you could access it from within Outlook Session so when your Outlook able to login to Office 365, you could manage the calendar items directly from VBA. So, make sure you select the correct account in case there are multiple accounts, otherwise use the default one if single account. Using VBA, you will just select the calendar folder by using GetDefaultFolder(olFolderTasks) or GetDefaultFolder(olFolderCalendar), and then you iterate the object within as a CalendarItem objects. There is a specific way for exporting to new PST file, you should attach a blank new PST file for this purpose. It uses an AddStore method of Outlook namespace object. There is no built-in method for creating new store, so it must use Mapi library or you create a blank PST file. Let me know if you are interested to discuss it with me. Best Regards, Khamid Note: - I have my own Office 365 I could use for the development - per my review there is a method on Namespace object which can be used for creating a new PST file, so we are good to go with purely VBA for Outlook
$1 000 AUD om 3 dager
5,0 (7 omtaler)
4,5
4,5
Brukeravatar
Hey there, I have 4 years of working experience in web technologies and I have a strong working knowledge of every possible framework which is in the market. In terms of client-end I know: VBScript, Microsoft Outlook and Excel VBA Also I have done tons of work on freelancing career. I am waiting anxiously for a positive response from your side. And I have read your requirements as well. Thanks and regards, Shamshad
$1 500 AUD om 27 dager
0,0 (0 omtaler)
0,0
0,0
Brukeravatar
Hello! I have discovered about your project Outlook VBA - custom archiving app I am skilled in VBScript, Excel VBA and Microsoft Outlook, so I'am totally sure I can deliver Your project ! Please contact me to discuss more regarding this project. Thank you
$1 250 AUD om 3 dager
0,0 (0 omtaler)
1,8
1,8
Brukeravatar
Hi! Native English speaker, experienced with VBA for Outlook. In the past, I've created entire systems around shared mailboxes/calendars. Can definitely get this done for you but I'd like to know a bit more about the specifications. Just send me a message if you'd like to discuss the details!
$1 200 AUD om 7 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

AUSTRALIAs flagg
Sydney, Australia
0,0
0
Medlem siden jun. 11, 2021

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.