Outlook.... What to do?

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
My company is migrating from Lotus Notes to Outlook 2010 this weekend.... Woooo! Now, obviously the first thing I'm going to want to do after changing my personal settings is to make it do cool stuff (probably with VBA and likely humorous or devious if possible). My question is, what cool stuff can you think of for me to try first?
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Atroxell

Active Member
Joined
Apr 18, 2007
Messages
419
Well, this doesn't really qualify as "cool", but I found it helpful...

Because of the nature of my work andthe limited amount of space we're allowed for our email, I found it necessary to save my emails to a network drive. So I wrote a macro that saves all of my emails to a secure drive that only I have access to.

As the macro runs, it saves each email by sender's name and date. Each user gets their own folder usingtheir name. Each folder below the users name is identified by the month/year I got the email. In addition to saving the email, it also saves any attachment that came with the email. Both email and attachements are appended with a date time stamp that corresponds to the date and time that the email was sent. So if someone walks up to me and says "Bob sent you an email in July that said...", I am able to find any email Bob sent me in July. Or any attachment.

There is a downside...

IT hates my macro. The first time I ran it I saved about 3 GB of emails and attachments to my personal drive. When they surveyed disk usage, I got a nice little email asking me to remove the excess junk from my drive.

But there's also an upside...

I told them I would delete my emails if they could guarantee me that they could find any email (or email thread) I ask for. They said yes the could. I asked them if they were willing to take responsibility for anything that I could not find and that they had lost. (This is critical with the work I do.) They said they would.

We now have this little email chat on about an annual basis. And IT has done a wonderful job of living up to their word so far.
 

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
That's not a bad idea! I don't need to save ALL my emails, but perhaps I can put some rules around what it captures. Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,324
Messages
5,600,956
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top