Excel Replace Asterix and Tilde

Example 1: How to find and to replace numbers To replace wildcard characters (*) in a numeric value in a worksheet cell, follow these steps: Type 494** in cell A1. Select cell A1. On the Edit menu, click Replace. Note In Microsoft Office Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace. In the Find what box, type ~*. To do this, press TILDE, and then press ASTERISK. In the Replace with box, type 2. Click Replace. Cell A1 now reads 49422. Notes When you click Replace All, Excel makes the … Continue reading Excel Replace Asterix and Tilde

Outlook 2010 Internet Message Headers

Message Headers are a key way to look at the technical information about email that is sent to you. It helps IT people determine the back ground on the message such as its origin and the route it took to get to your mail server. Since the 2007 version of outlook, it has become increasingly more hidden. Here is how to find it. To see the Internet headers for an email message Open the message in its own window (not the reading pane) in Outlook 2010. Click File, and then click Properties. Look for the section Internet headers at the … Continue reading Outlook 2010 Internet Message Headers

Office 365 – How to Change Primary Email Address For a User

Scenario: Your company uses a sign in domain however some users need to be able to send from a different email as their primary email address. Example: You sign in with  Your outgoing email address The Office 365 graphical user interface does not currently give you the ability to change this setting. So you need to be able to get dirty with PowerShell and here are the steps. Prerequisites: Download and install Microsoft Online Services Module for Windows PowerShell Download the 32-bit module Download the 64-bit module Stage 1 – Setting Up PowerShell to receive the commands Run the PowerShell … Continue reading Office 365 – How to Change Primary Email Address For a User

Office 365– Send email from Alias

Ok you have got multiple email addresses and you want to be able to send from the same Office 365 account. If you have been administering Exchange for any time you know the work around is to use a POP3 account. The question is how do you get the workaround to work with Office 365? For those of you reading and asking the question how do I receive email from multiple addresses, please note that this post does not cover this topic. More Info on Receiving Email from Alias. Prerequisites: You need a computer with Outlook Installed. You need to … Continue reading Office 365– Send email from Alias