Find Jobs
Hire Freelancers

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

$10-30 USD

En curso
Publicado hace más de 9 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 6578385

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (18 comentarios)
4,1
4,1
13 freelancers están ofertando un promedio de $125 USD por este trabajo
Avatar del usuario
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 en 2 días
5,0 (62 comentarios)
7,4
7,4
Avatar del usuario
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 en 7 días
4,9 (38 comentarios)
6,1
6,1
Avatar del usuario
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 en 3 días
5,0 (37 comentarios)
5,1
5,1
Avatar del usuario
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 en 5 días
5,0 (13 comentarios)
4,5
4,5
Avatar del usuario
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 en 2 días
5,0 (28 comentarios)
4,7
4,7
Avatar del usuario
Hey there, we write this macro to create appointments based on the confirmation emails, please reply, we can discuss further, thank you !
$83 USD en 3 días
4,8 (15 comentarios)
4,1
4,1
Avatar del usuario
Hi, I understood your requirements, after receiving auto mail appointment should create in outlook PM me sample mail format Thanks
$277 USD en 1 día
5,0 (3 comentarios)
3,1
3,1
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Seattle, United States
5,0
14
Forma de pago verificada
Miembro desde oct 17, 2004

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.