In Progress

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

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][url removed, login to view], [at][url removed, login to view], 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][url removed, login to view] should automatically go to the Bluejay project folder and nowhere else.

Any sender with the domain of [at][url removed, login to view] 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][url removed, login to view] 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][url removed, login to view] 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 [url removed, login to view] and mycompany.com. If it's [url removed, login to view], 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][url removed, login to view] 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.

Skills: Microsoft, Visual Basic

See more: write what i say, write report to me, write reports, write every day, write anything you want, write about anything you want, who to write report, what is a general manager, want to be a manager, wanted it manager, sort sort sort, sort sort, sort function c, report how to write, needs of a manager, i want to write a report, i want to be a manager, i need someone to write a free report, i can write my name, how to write reports, how to write on line, how to write email, how to write a report on an event, how to write a project report, how to write a function in visual basic

About the Employer:
( 0 reviews ) calarasi, Romania

Project ID: #4905436

Awarded to:

paris2785

VB and VBA expert for over a decade. Master in Information Systems.

$140 USD in 7 days
(15 Reviews)
4.3

7 freelancers are bidding on average $171 for this job

expertatwork

Hey aliiina16, You have not attached the screenshot that you are talking about. Meanwhile, which OS are you using - MAC or WINDOWS ?

$45 USD in 3 days
(28 Reviews)
4.3
angan

I can do this

$300 USD in 15 days
(12 Reviews)
4.0
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$194 USD in 6 days
(3 Reviews)
3.2
Ayan

Hi, Please check PM.

$45 USD in 1 day
(9 Reviews)
3.1
tomislav1975

Pls read review of my satisfaid customers, I can do this.

$250 USD in 15 days
(4 Reviews)
3.0
MattGofStP

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 More

$225 USD in 7 days
(0 Reviews)
0.0