Quick Bytes IT Stuff

Outlook is a very good tool, however if it gives some issues, it can ruin your day or your mood to work. Well, as the odds say nothing is perfect and even the flowers on the field that looks so beautiful will one day fade away. Same goes with our electronic devices, you just don’t know when it will go south. It might even give you issues when you needed it most to work properly, and sometimes that will be the time that it will not work as expected. Anyway, problems will always be there. The only question is, how will you face the issue or problem? For Outlook not responding and also the network or WiFi keeps disconnecting even though your phone or other devices or laptop has no issue to the network. It seems that the laptop has been singled out, and that’s the only device on the network that is not working. There are various approaches to solve this issue. Sometimes, it’s the same issue Outlook not responding or no network, but then different ways to resolve the problem. Yes,...

Advance Threat Protection aka ATP which is now called Microsoft Defender in office 365, is one of the licenses offered by Microsoft. If there are hundred accounts in O365, tracking which account that doesn't have ATP or Microsoft Defender license is just troublesome. Of course, PowerShell will come into rescue for this kind of issue. One liner code below in PowerShell will check which Office 365 accounts does not have ATP or Microsoft Defender license assigned. Get-MsolUser -All | Where-Object {$_.licenses.AccountSkuId -notcontains 'contoso:ATP_ENTERPRISE'} | Select-Object userprincipalname,licenses | export-csv c:\temp\office_365\no_defender_license.csv Replace contoso with your domain. Or run this command to see which licenses are assigned or available in your tenant. Get-MsolAccountSku | select -ExpandProperty ServiceStatus The PowerShell command checks which accounts does not have ATP assigned; which means that if you have 100 of guests or client user...

 Managing Office 365 via PowerShell CLI needs to have proper access rights or privileges.   First step is to connect to the Office 365 domain via an elevated PowerShell terminal. Connect-exchangeonline -userprincipalname email-admin@domain.com PowerShell for Office 365 is very handy. Below are just a few examples that might save some time and focus on other important task, or just simply enjoying more coffee time. Get or list aliases of a mailbox, email account or group mailboxes. Get-UnifiedGroup -Identity "Name of the Mailbox" | Select-Object DisplayName,@{Name=”EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_ -LIKE “SMTP:*”}}} | ft -wrap List the Primary Email of a group's mailbox using the group name. Get-UnifiedGroup -Identity "Name of the Mailbox"   | Select-Object DisplayName,PrimarySmtpAddress Change group primary email. Set-Unifiedgroup -identity "Group Name to change email" -primarysmtpaddress new-email@of-the...

If you have a subscription to Office 365, chances are you have OneDrive configured in your system and is linked to your email address. OneDrive is quite good since you can have your data on the cloud, of course you also have to use common sense and what data you are uploading to the cloud. OneDrive will come handy since you just need internet connection and you will be able to retrieve your notes or data anywhere. But how to check which email address is linked to your OneDrive? Well, there' a simple way using PowerShell to view registry keys. A one liner PowerShell script will come-in handy to do these kind of task. Here’s the code, if using Hotmail, or Li ve email: ( Get-ItemProperty -Path HKCU:\Software\Microsoft\OneDrive\Accounts\Personal -Name useremail ) . useremail For OneDrive Business use this code: ( Get-ItemProperty -Path HKCU:\Software\Microsoft\OneDrive\Accounts\Business1 -Name useremail ) . useremail Then the value set on th...

How to type equal sign "=" in Excel without evaluating? Typing equal sign in Excel will trigger Excel to evaluate the contents or the formula that is being typed. But how to type equal sign plus the contents without evaluating the formula? Or how to display a formula in a cell using Excel? In VBA, Excel Macro, VBscript and VB.Net; to put comments or remarks on the code is to use single quote. A single quote tells the engine that whatever that follows from the quote is a string and not a command and should not be evaluated. In this way, you can type anything after the single quote “ ‘ “. So, this goes the same way in the Excel interface. If you want just to show the formula for remarks or whatever purposes but don’t want Excel to evaluate the contents, then just type a single quote before the equal sign or the formula. Example: ‘=1+1 Excel will just display =1+1 It will be treated as a literal string. Of course, without the single quote ...

Office 365 PowerPoint shows an error contact system administrator when opening the file. The error if interpreted literally shows that a system administrator is needed to fix the issue due to a security or permissions issue. Notification errors or any errors that are displayed to inform the user that some processes have gone wrong while processing or opening the file are quite helpful to begin troubleshooting. But some errors are quite generic or does not really point to what type of solution should be done to resolve the issue. Literally interpreting the error to resolve the issue sometimes work but sometimes it won’t work as well. For this error it seems like a permission issue but it’s not. The first thing to try to eliminate the issue is to open the file manually, like going to “File”, select “Open”, then browse to the folder location of the file and open the file. If the file can be opened, then security issue or permission issue is not a concern. ...

How to search for a string in the body of Outlook emails? How to search for a string in Outlook emails using VBA? How to find a string in Outlook email body using VBA? Outlook VBA code below searches a string on the email body and move the email to a specified folder. Replace variables below with the actual folders and string to search in Outlook: Destination_Folder_01 Folder_to_be_Searched string to be searched Folder_to_be_Searched - all emails in this folder will be searched and if the string matches the will be moved automatically to the destination folder.  string to be searched - this string will match on the body of the emails Sub MailItemContent_Move_Search() Dim olItem As Outlook.MailItem Dim sText As String Dim myNameSpace As Outlook.NameSpace Dim myInbox As Outlook.MAPIFolder Dim myDestFolder2 As Outlook.MAPIFolder Dim mySearchFolder As Outlook.MAPIFolder Set myNameSpace = Application.GetNamespace("MAPI") Set myInbox = my...

How to insert a different section or page in a Word document? How to mix portrait and landscape in a Word office 365? If you are writing a thesis, a report or an article that you need to insert a landscape layout in a specific page in Word document but your orientation all long is portrait and changing the orientation causes the whole layout to change. Inserting landscape in a specific page in a word document can be done by inserting section breaks. Let’s just make a basic example. Let’s say you have 3 page document and you want that first page in Portrait mode, second page in landscape and third page in portrait layout also. First, click on “home” tab, click the “show/hide paragraph marks” option or see the icon below. Enabling this option the section breaks, spaces and tabs will be visible. But what we are interested is to see the “section breaks”. In the first page position the cursor on the last area at the bottom of the page. In Word 2010, cli...