Here’s a question from Diane:
I am creating a bulleted list in Word. By default, all bullets are colored black. is there are way to switch the bullets to a different color, say red?
Sure Diane. Please read on this tutorial which is applicable for all Office 2016 applications.
Set color bullet point:
In Word 2016:
In Excel 2016:
Office does not provide bullet option in Excel and OneNote separately. So to use bulletin read the procedure below.
In OneNote 2016:
Thanks for reading.
Last updated: October 2018
Applicability: Office 365, 2019, 2016,2013. Windows operating systems.
Here’s a question from Selena:
I used to read only Outlook mail in Outlook 2016. But I’ve heard that i can also use Outlook to access my Gmail and Yahoo Mail accounts. Is so, how to configure my Yahoo and Gmail mailboxes in Outlook 2016?
Thanks. Read further to learn how to add your Yahoo and Gmail mailboxes into Microsoft Outlook 2016.
If you are using a MAC OSX operating system, you might want to look at our guide for adding GMail to Outlook on MAC.
Windows users, kindly proceed as following:
We all know how distressing is to find out that we might have accidentally deleted some important email from our mailbox and don’t seem to be able to find it. Luckily, Outlook comes well equipped to handle those situations. In this post we will discuss the various recovery option for deleted email in Outlook 2013 and 2016.
Recover mails from the Deleted Items folder:
Usually all our deleted mails from inbox will be stored inside the Deleted items folder. Hence we can recover it easily and move it back to our needed folder. Steps are given below.
Recover permanently deleted mails:
If unfortunately we have deleted the mail by using shift+delete, then the mail wont be saved in the deleted items folder. But there is another way to recover it.
Enjoy. Thanks for reading!
Last updated: June 2019
Applicable to: Office 365, 2016, 2013, 2010, 2019 ; Windows 10, Windows 7 operating systems.
In Microsoft Office, we use Visual Basic for Applications (VBA) for creating custom programs that enhance Office’s basic functionality and saving user time by automating repetitive tasks. We refer tho these VBA program as Macros.
Unlike other Office apps, Outlook doesn’t offer a simple Macro recorder that allows us to record user actions and auto-generates the required VBA code for us in the background. Therefore, if we want to add our own custom functionality to Outlook, we’ll need to learn to write simple VBA programs and incorporate them into our Outlook session.
In this tutorial, we will focus on learning the basics related to using VBA in Outlook:
Before you start writing your code, you may need to set up your Office development environment. Sounds fancy isn’t it? Actually it’s quite a simple procedure:
This simple snippet creates a new email message item programmatically; then it sets the to, subject, body text and CC fields. Finally it displays the message in Outlook so you can review and send it.
Public Sub CreateMail() Dim MyEmail As MailItem ' Create a new Outlook message item programatically Set MyEmail = Application.CreateItem(olMailItem) 'Set your new message to, subject, body text and cc fields. With MyEmail .To = "firstname.lastname@example.org" .Subject = "Insert your message subject here" .Body = "Insert your email text body here" .CC = "email@example.com" End With MyEmail.Display End Sub
Advanced Note: You are able to use predefined Outlook templates when defining new emails with VBA. In order to do that, you’ll need to leverage the method CreateItemFromTemplate and specify the location of your oft file.
If you want Outlook to send out the email you have just created automatically, you can add the following line to the code posted above. Paste the following line before the End Sub statement.
In many instances you would like to automate sending an email with a file attached to it. This could be a Word document, Excel spreadseheet, Powerpoint presentation, PDF documents etc’. If you want to send an email with attachments programmatically, use this code:
Public Sub CreateMailWithAttachments() Dim MyEmail As MailItem ' Create a new Outlook message item programatically Set MyEmail = Application.CreateItem(olMailItem) 'Define your attachment folder path and file name - modify this part as needed Dim AttachFolder, AttachFile As String AttachFolder = "C:\" AttachFile = "test.txt" 'Set your new message to, subject, body text and cc fields. With MyEmail .To = "recipient@my_server.com; mysecondrecipient@my_server.com" .Subject = "This is your message subject" .Body = "Insert your email text body here" .CC = "cc@my_server.com" .Attachments.Add AttachFolder & AttachFile End With MyEmail.Display End Sub
The following snippet, creates a task and assigns it to another individua and sets the task subject and body text.
Public Sub CreateTask() Dim MyTask As TaskItem ' Create a new Outlook task Set MyTask = Application.CreateItem(olTaskItem) 'Set your new task recipients and information fields With MyTask .Assign .Recipients.Add "taskrecipient@my_server.com" .Subject = "This is your task subject" .Body = "Insert a thorough explanation of your task here." End With MyTask.Display End Sub
Few readers asked how to automate saving emails to HTML. The code below accomplishes exactly that.
Note: Ensure that you launch this code only on open emails.
Public Sub SaveAsHTML() On Error Resume Next Dim MyWindow As Outlook.Inspector Dim MyItem As MailItem Dim FilePath As String FilePath = Environ("HOMEPATH") & "\Documents\" & "\" Dim ItemName As String Set MyWindow = Application.ActiveInspector If TypeName(MyWindow) = "Nothing" Then MsgBox ("Kindly open an email to save") Else Set MyItem = MyWindow.CurrentItem ItemName = MyItem.Subject ' File name will be identical to the message subject With MyItem .SaveAs FilePath & ItemName & ".html", olHTML End With End If End Sub
For this example, we’ll use the following Visual Basic macro code which allows to create an e-mail message programmatically.
Our next step will be to insert one of the VBA code snippets displayed above, or other code, into your Outlook session. Here are the steps to follow:
Unlike in Excel for example, which allows you to store macros in the personal.xlb file or in specific spreadsheets; all Microsoft Outlook macros are stored in one global file in your file system: VBAProject.otm. The file can be found at: C:\users\<your_user_name>\AppData\Roaming\Microsoft\Outlook.
Our next step is to insert a small button which will allow us to easily run the macro. For simplicity, we’ll insert this button to the Quick Access toolbar.
Note: You can use a similar procedure to place your icon in the Ribbon itself instead of in the Quick Access Toolbar.
This step is optional and should be followed only if you receive an error message when running your newly created macro.
Tip: assign notifications for only digitally signed macros or set notifications for all macros .
Last but definitely not least, now it’s time to run your newly created macro.
Last updated: February 2019
Here’s a question i got from a colleague:
I am using Microsoft Word to prepare a summary document for a project i am about to hand at university. My question is related to adding borders into Word.. Is there a way to create a boxed page and put it in my document? I need to have an outside decorative four sided border in all my doc pages for the project review.
Yes, tou can definitely add a custom box border in your Word document pages and glad that we could help. Note that you can define several border styles and apply them to different sections of your doc, so that the first page has a custom look and feel. Read further for the detailed procedure.
That’s it, we just added a border to our word document. Thanks for reading!
Last updated: July 2018
The other day, i received the following note from a friend who uses Outlook to manage his mail, contacts, tasks and calendar; and also happens to travel quite a bit in between:-):
Hey, don’t know if you saw that the Outlook calendar is now shipping a tiny weather widget that displays the current conditions on a predefined city / location. Was wondering whether there is some setting or configuration that will allow me to hide that weather bar in my Outlook calendar as i find it a bit distracting. Any pointers are appreciated
Yep, one of the new features introduced in Outlook 2013 is the display of a simple weather conditions forecast in your calendar header. For me, that’s quite a nice feature, as it saves me a time to lookup weather forecast conditions in Accuweather, Weather channel and so forth. That said, removing the bar from Outlook is pretty straightforward fortunately.
The weather section comes enabled by default, however, if it happens to be disabled in your installation, you can add it back quite easily.
All you’ll need to do is to proceed as indicated above. he only difference is to check the “Show weather on calendar” check box, and that will do the trick for you.
If you often send out email to large audiences, for example the other students in your class, you might want to consider setting up an Outlook distribution list (referred also as Contact group). The biggest benefit for you is that when sending email, instead of typing your recipients addresses one by one, you’ll just send an email to one recipient – your class distribution list.
Let’s see how that works.
Creating a contact group in Outlook:
In Outlook, navigate to the Home tab.
Hit the small arrow next to New Items, hover on More Items and select Contact group.
In the Name field, Provide your distribution list a meaningful name.
Now hit Add Members.
Here you can select email addresses from your Outlook Contacts, Address Book, or just type addresses from scratch. This might include your contacts from Facebook, Linked in and other social networks, if you have synced them to Outlook. Corporate users might be able to select also recipients from their Exchange Global Address List (GAL).
Note that you are able to Remove Members as needed from the list.
Once done, hit Save and Close.
Your distribution list is ready to be used.
Note for Business users: unless provided permission from your Exchange Administrator, you won’t be able to share the list of others in your company.
Sending an email to your contact group:
Hit on New Email.
Hit the To, CC or Bcc buttons as needed. Pick your newly created contact group and hit OK.
Write and send your email and that’s it.
Thanks for reading
Last updated: February 2019
Applicable to: Outlook 2019 / 365/ 2016 / 2013 / 2010; on Windows computers.
Here’s a question from a reader:
Quite often i need to create a few instances of the same meeting requests in Microsoft Outlook. Are you aware of a simple way to duplicate a occurrence of an Outlook appointment by using copy and paste, as creating a meeting series for scheduling a few meetings might be somewhat of an overkill. Help is highly appreciated!
Thanks for your questions. Keep those coming!
You can easily copy and duplicate meeting entries in your Outlook calendar by highlighting the meeting in your calendar view and simply copying it by hitting Control+C , and then paste it to your preferred time by hitting Control+V . An alternative method is to simply right click your meeting in Calendar and drag it to the right time slot.
After doing this, make sure to review your meeting subject, location and invitation content as those might have changed.
When using this at work on Microsoft Exchange server, you also might need to review the list of attendees and their availability, as people might be tied in other meetings. If applicable, go ahead and check the availability of a meeting room and any other equipment/resources for your meeting.
Duplicating appointments and meetings within the same Outlook calendar is not supported in Microsoft Office for MAC OSX.
Using the same process you can duplicate a meeting across multiple calendars defined in your Outlook client.
Outlook allows you to copy an entire calendar including all appointments, meetings and events.
In order to copy an entire calendar, proceed as following:
Sometimes you don’t want to copy the entire meeting, but only the attendees list. If so, proceed as following:
A couple of readers asked whether there is a simple process for creating a meeting or appointment from an email they got into their inbox. This is pretty helpful as it could be used to improve your follow up on important email.
Here’s is a quick trick to accomplish that: in your Outlook inbox locate the email you would like to turn into an appointment, left click it and drag it to the Calendar tab in the bottom of your screen. Outlook will immediately open an appointment, that will have the email text copied into the appointment details. From there, go ahead and set your subject, locations and invited people.
Give it a try and let us know in case of any question.
In today’s productivity tip, we’ll learn how to quickly export your LinkedIn and Facebook profile contact people into a file, so you can then maintain a clean, consolidated list of people you are in touch with. This will allow you to export and backup your contacts list and obviously use your contact email addresses for email communication via Outlook or Outlook.com.
Saving your LinkedIn contacts to a file:
Exporting your Facebook contacts:
The simplest way to export your Facebook email addresses is by leveraging the integration with Yahoo Mail.
To Import LinkedIn & Facebook contacts into Outlook 2016:
To Import LinkedIn & Facebook contacts to Outlook.com:
Last updated: February 2019
Applicable to: Office 365, 2016, 2013, 2019; Windows 7, 8 and 10.
Here’s a question from Johny:
Greetings Easytweaks team! A co-worker told me that he is using pst files in order to keep backups of his email box, calendar, journals and contact people. Could you elaborate more about how to insert Outlook data files and using them for daily archiving of my mailbox? I love MAC OSX Sierra and wish to use Outlook on the MAC, so i guess other question i have is whether i can use pst on MAC OSX. Many thanks!
Outlook personal folders are very useful as they allow us to create offline copiers of our mail, contacts and tasks for offline access, data backup or transfer to a different computer. Personal folders are represented in the Windows operating system by the .PST suffix.
In this guide we will learn how to create and open personal folders, as well as export your email to a PST file for backup.
We’ll first teach you how to create Outlook folders using the Open/Export wizard. This will allow you to package all existing email / contacts and calendars in one shot. For advanced users, we’ll describe how to create the pst files manually. Once you have defined the data file, you can go ahead and populate your personal folder with specific email, calendars and contacts to it. Keep reading for the details.
Couple of readers asked us about looking up for those .pst file after creating them. The easiest way to find your files is simply by searching for *.pst in Windows Search.
Microsoft Outlook for MAC doesn’t use Outlook Data Folders. That said, it’s definitely possible to import pst files created on WIndows to Outlook for MAC.