Find Jobs
Hire Freelancers

Write a Macro for Outlook to Sort Incoming Emails in Specific Manner - repost 2

$30-250 USD

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

$30-250 USD

Pagado a la entrega
My inbox is quite small, so it is absolutely essential for me to sort incoming emails. Doing it manually is very time-consuming and I receive hundreds of emails every day. I have already exhausted the Rules function in Outlook and I can't add anymore. I'm hoping someone can write something to get me started so that I can flesh out the entire Macro needed. I've already attempted to write something, but it isn't working. This is how I need emails sorted: 1. Project the email is about 2. Month of Receipt 3. Group of Sender 4. Name of Sender I also want an "other" folder for each project in the event that the email does pertain to that project, but that sender hasn't been defined as part of a group. I want to be able to go into VBA and manually define new senders and keywords, etc. as they come up. I've attached an image of how I'd like the folders to be organized. The Macro must be able to create new folders for senders that fall into specific categories. HIERARCHY 1 For example, I have the Bluejay Project, the Red Cardinal Project, and the Yellow Canary Project. Sponsors and Program Office folks will always have the same domain: [at][login to view URL], [at][login to view URL], etc. I might also get emails from a manager at those fictional companies requesting a report, and they would have the same domain. But, that domain will ALWAYS be associated with THAT project. Anything with [at][login to view URL] should automatically go to the Bluejay project folder and nowhere else. Any sender with the domain of [at][login to view URL] could either be in Management or Analytics Team. HIERARCHY 2 The month stamped on the email would dictate which month subfolder the email goes to. HIERARCHY 3 The group that the sender falls in will need to be defined by me and I will need to be able to add onto it. So, any email from needs to go to the Program Management folder under her folder. An email from sbaker[at][login to view URL] that says "Hey, I know you're busy with Yellow Canary, but I wanted to know what's up with Bluejay when you get a minute".Sbaker will only email for general company stuff OR Bluejay, so, I need the macro to ignore the "Yellow Canary" part and focus on whether "Bluejay" is in the email. If it isn't, it would need to go to an entirely different folder. HIERARCHY 4 Anything with [at][login to view URL] in the sender email will need to go to Analytics Team or Management based on a list in which I can define who belongs to which group. For the Reporting folder, anyone could fall into that. The Macro would have to look for anything that says "report request" or "can you create a report" AND a keyword for the project "can you create a report for Bluejay". This would apply only to domains in [login to view URL] and mycompany.com. If it's [login to view URL], it shouldn't go to the Bluejay folder. Notifications would always be from one source, which is a particular technology being used. If the domain is [at][login to view URL] and has "Notification" in the subject line, it needs to go to the Notifications folder. Completed reports will also come the same domain. The subject line will say "Report Completed" and needs go to the Completed Reports folder. If you have any questions, please feel free to reach out to me.
ID del proyecto: 4905436

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 10 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
VB and VBA expert for over a decade. Master in Information Systems.
$140 USD en 7 días
4,7 (15 comentarios)
4,3
4,3
7 freelancers están ofertando un promedio de $171 USD por este trabajo
Avatar del usuario
Hey aliiina16, You have not attached the screenshot that you are talking about. Meanwhile, which OS are you using - MAC or WINDOWS ?
$45 USD en 3 días
4,9 (28 comentarios)
4,3
4,3
Avatar del usuario
I can do this
$300 USD en 15 días
4,9 (12 comentarios)
4,0
4,0
Avatar del usuario
Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards
$194 USD en 6 días
5,0 (3 comentarios)
3,2
3,2
Avatar del usuario
Hi, Please check PM.
$45 USD en 1 día
5,0 (9 comentarios)
3,1
3,1
Avatar del usuario
Pls read review of my satisfaid customers, I can do this.
$250 USD en 15 días
5,0 (4 comentarios)
3,0
3,0
Avatar del usuario
I am a software engineer with two years of experience in Microsoft office automation including excel, word, and outlook. I would be happy to do this for you. Can I please get further details, so I can begin? Thank you, Matt
$225 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de ROMANIA
calarasi, Romania
0,0
0
Miembro desde sept 7, 2013

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.