00:00This tip is going to really really make your life very easy. Check this out. I'm actually scheduling Microsoft Outlook
00:05appointment from Microsoft Excel and this is how you do it. You start by creating a table that looks something
00:11like that in Excel with date, time, duration. This is going to be in minutes. Subject will be the appointment
00:18subject and colors. There's a few colors that are supported by Outlook and these are the colors. And after that
00:24a button where we can assign a macro to it.
00:28So after that you're going to go right click on your worksheet name and go view code. In here you're
00:34going to go to tools and you're going to add a reference library in it. Make sure you have Microsoft
00:39Outlook 16.0 object library enabled like this. And after that go OK. Now you're going to right click on
00:47Microsoft objects and go insert module. In here in the module you're going to paste this VBA script. If you
00:56like this VBA script.
00:58To be sent to you please leave a request on the comment or DM me tip 366. And I'll send
01:04you this VBA script. In this VBA script there's a couple of things that you can customize.
01:09One thing is this one here. The sheet name is sheet number one for me here. As you can see
01:14it could be different on yours. If you've got this VBA script.
01:17Just make sure that you modify them. And if you decide to modify this table in different way. Like date
01:24is in C3. Time is in C4. Everything is in column C here.
01:29So if you look at the VBA script here. These are the spots you have to modify. This is going
01:34to be your date. It's going to be your time.
01:37And this is going to be your duration. Subject. Category. Which is your color itself. After that press control S
01:44to save your VBA script.
01:46And let's minimize this guy here. Now you're going to right click on the button here. Assign macro.
01:50And you're going to assign the same function that you just created on your module.
01:55And click OK. Let's save it. And now you can start scheduling your Outlook using your Excel.
02:02You can assign say for example 9am. Like that. On the 21st. Let's say it's going to be for an
02:11hour meeting.
02:12Which is 60 minutes. And you say maybe you're going to say some Cynic meeting. And you can assign the
02:17color for it.
02:18Maybe it's urgent. You're going to put red. And if you schedule it. You can see it will appear on
02:23your Outlook calendar.
02:33Watch out.
02:33How the way, everybody.
02:34How about it?
02:34How about when it recover.
02:34How about it?
Comments