Find Jobs
Hire Freelancers

Create an Outlook VBA macro to parse incoming airline confirmations and create calendar appointments from othem

$10-30 USD

In Progress
Posted over 9 years ago

$10-30 USD

Paid on delivery
This project is to build a simple macro that I can install into my Outlook 2013 client, and set a rule to use for all incoming airline confirmations from Alaska Airlines. When it processes an Alaska Airlines flight confirmation email, it should create an appropriate number of new Outlook appointment items with the following details set based on the inbound confirmation email. Below I'll use <<>>'s to indicate fields that should be parsed in the inbound confirmation email and placed into the appointment. Subject: <<Depart time and timezone>> <<Airline>> #<<Flight #>> - <<Depart airport>>-<<Arrive airport>> arriving at <<Arrive time and timezone>> Location: Ticket #<<Ticket number>> / Fare: <<Cash fare paid plus any miles paid e.g. $5.00 + 25,000 miles>> Date: <<Departure date>> Start time: <<Departure time>> End time: <<Arrival time>> (may be on next day for overnight flights) With all those fields filled out, the appointment should be opened on-screen for any final manual editing or overrides or notes. Note that there could be more than one appointment created from each email, for example an email could have a round trip of 1-stop flights (4 segments = 4 appointments total). A sample confirmation email from Alaska Airlines will be provided upon request, since it has personal info in it.
Project ID: 6578385

About the project

13 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Greetings for the Day!!! I have 5 years of Experience in VB, VBA macros with SAP, Internet Explorer, PDF & Text Files, MS Access and SQL Server Databases. hope if awarded with this project i can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$25 USD in 1 day
5.0 (18 reviews)
4.1
4.1
13 freelancers are bidding on average $125 USD for this job
User Avatar
Hi there. I have developed several outlook add in's so far and I recommend the same to you. They are far more professional than VBA macros. It shall be installed on your outlook client and would scan every incoming email to separate the flight confirmation emails. Then it would create appointments accordingly. It shall be compatible with outlook 2010 and 2013. Kindly discuss if my proposal interests you, otherwise it can be done in VBA too. Regards.
$160 USD in 2 days
5.0 (62 reviews)
7.4
7.4
User Avatar
MS Office expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. For any questions, please let me know. Paris
$160 USD in 7 days
4.9 (38 reviews)
6.1
6.1
User Avatar
ey Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav Jha
$263 USD in 3 days
5.0 (37 reviews)
5.1
5.1
User Avatar
Hi there, I would recommend you to use VBA code instead of standard Outlook Plug-In. Why? Please see below: - standard Outlook Plug-In may require reference to additional built-in DLL's or to a third-party components. It could also be complicated to apply it on different Outlook version, different computer/laptop etc. - VBA is readable; anyone can read it. Outlook Plug-In is usually compiled in DLL and one cannot read it source code. That means a freelancer could inject your plug-in with unwanted lines of code to allow him/her access to your computer, privacy etc. Of course you could get the source code from a freelancer and compile plug-in by yourself but that would probably initiate additional costs... So I would go with existing Outlook rules (easier for you to maintain) to move incoming mails to specific folder (in case you receive various types of emails not only itineraries) with the VBA code in background waiting on new messages that are being moved by Outlook rules. Once email get processed it could be either moved to Archive folder (you name it) or marked as complete (check mark).... Please visit my profile. I'm not doing freelancing often but with have been able to continue work with most of my clients here at freelancer. Of course in such cases we are not using freelancer but straight communication ... Thank you for your time. Osman -
$220 USD in 5 days
5.0 (13 reviews)
4.5
4.5
User Avatar
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done projects related to VBA and VB in past. I am currently going through all the attachments to have a clear view. If you like my proposal,lets start. Thanks Abhinov
$62 USD in 2 days
5.0 (28 reviews)
4.7
4.7
User Avatar
Hey there, we write this macro to create appointments based on the confirmation emails, please reply, we can discuss further, thank you !
$83 USD in 3 days
4.8 (15 reviews)
4.1
4.1
User Avatar
Hi, I understood your requirements, after receiving auto mail appointment should create in outlook PM me sample mail format Thanks
$277 USD in 1 day
5.0 (3 reviews)
3.1
3.1
User Avatar
As mentioned in summary, I have 15+ years of experience as programmer in MNCs. I have done many VBA scripts and tools for open source community also, connecting almost all the Microsoft Office products. My logics behind OUTLOOK scripts is my asset.I have done many contract based projects. I can submit samples of our work which sealed our contract with various companies. So I am looking forward for such professional bond with you.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Seattle, United States
5.0
14
Payment method verified
Member since Oct 17, 2004

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.