Find Jobs
Hire Freelancers

Outlook VBA - custom archiving app

$750-1500 AUD

Closed
Posted almost 3 years ago

$750-1500 AUD

Paid on delivery
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".
Project ID: 30493343

About the project

5 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $1,140 AUD for this job
User Avatar
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 in 3 days
5.0 (7 reviews)
4.5
4.5
User Avatar
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 in 27 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
1.8
1.8
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
0.0
0
Member since Jun 11, 2021

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.