User Profile
Smith_J
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Exchange 2010 Hybrid Migration to Office 365.
Sign in to Microsoft 365 or Office 365 with your work or school account. Choose Setup > Domains. On the Domains- page, click Add domain to start the domain wizard. Choose Add domain On the Add a domain page, type in the domain name (for example, Contoso.com) you use for your on-premises Exchange organization and then choose Next. On the Verify domain page, select either Sign in to GoDaddy (if your DNS records are managed by GoDaddy) or Add a TXT record instead for any other registrars > Next. Follow the instructions provided for your DNS hosting provider. The TXT record usually is chosen to verify ownership. You can also find the instructions in Create DNS records at any DNS hosting provider for Office 365. After you add your TXT or MX record, wait about 15 minutes before proceeding to the next step. In the domain wizard, choose done, verify now, and you'll see a verification page. Choose Finish. If the verification fails at first, wait awhile, and try again. Do not continue to the next step in the domains wizard. You now have verified that you own the on-premises Exchange organization domain and are ready to continue with an email migration. You will finish setting up your domain after the migrations are complete.2.9KViews0likes0CommentsRe: Exchange 2016 on prem - ECP redirects to OWA
For the redirect issue, it’s recommended to refer to the workaround in below KB: Exchange Server 2013 or Exchange Server 2016 redirects to Exchange 2010 for OWA, Outlook on the Web, and ECP In addition, here's a article to get in detailed about Client Connectivity in an Exchange 2010 and Exchange 2016 coexistence, for your reference: Client Connectivity in an Exchange 2016 Coexistence Environment with Exchange 2010.16KViews0likes1CommentRe: WAC opens but will not connect to any servers
I discovered the problem. It is a design flaw in Windows Admin Center. Here is a User Voice ticket that describes the problem and work-around. Simply put, I'm giving FQDN server identifiers to WAC on my domain-joined laptop. It confirms that the server exists and that I've provided the correct credentials. Then it stores the server connection using the hostname of the server instead of the FQDN. Unfortunately, the cloud-based servers I'm targeting are not on my own domain - or any domain at all. So the hostname does not resolve. The solution is for me to put the hostname into my HOSTS file with explicit IP addresses. Very obnoxious, since the cloud-servers have dynamic IP's!4.8KViews0likes0CommentsRe: SharePoint Online Date calculation with JSON
You can use toLocaleDateString() function/operator in Column formatting to convert your date in friendly format. According to official documentation, toLocaleDateString(): returns a language sensitive representation of just the date portion of a date "txtContent":"=toLocaleDateString(@now)" ---> results vary based on user's locale, but en-us looks like "2/5/2019"8.2KViews0likes0CommentsRe: Excel SORT() and FILTER() functions are missing
If your data has empty rows and/or columns or if you are only wanting to filter a specific range, select the area you want to filter prior to turning Filter on. Failing to select the area leaves Excel to set the filter area. You can easily identify the rows as the row number will now be colored blue.12KViews0likes0CommentsRe: Can we create Tag inside Team using graph api?
You need to include entities, with type 'mention', in your message and the message of the text should include <at>username</at> for each entity mentioned. EDIT 1: When using https://graph.microsoft.com/beta/teams/{team-id}/channels/{channel-id}/messages on graph explorer { "error": { "code": "BadRequest", "message": "Value cannot be null.\r\nParameter name: Content", "innerError": { "request-id": "f0d4fed8-7726-4338-8a68-9685a690eab5", "date": "2019-07-02T12:46:14" } } }4.6KViews0likes2CommentsRe: Excel VBA help needed
1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so-called macros. In this chapter, learn how to create a simple macro. 2 MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program. 3 Workbook and Worksheet Object: Learn more about the Workbook and Worksheet object in Excel VBA. 4 Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA. 5 Variables: This chapter teaches you how to declare, initialize and display a variable in Excel VBA. 6 If Then Statement: Use the If Then statement in Excel VBA to execute code lines if a specific condition is met. 7 Loop: Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines. 8 Macro Errors: This chapter teaches you how to deal with macro errors in Excel. 9 String Manipulation: In this chapter, you'll find the most important functions to manipulate strings in Excel VBA. 10 Date and Time: Learn how to work with dates and times in Excel VBA. 11 Events: Events are actions performed by users which trigger Excel VBA to execute code. 12 Array: An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number. 13 Function and Sub: In Excel VBA, a function can return a value while a sub cannot. 14 Application Object: The mother of all objects is Excel itself. We call it the Application object. The application object gives access to a lot of Excel related options. 15 ActiveX Controls: Learn how to create ActiveX controls, such as command buttons, text boxes, list boxes etc. 16 Userform: This chapter teaches you how to create an Excel VBA Userform.952Views0likes1CommentRe: Error when trying to Share a Forms Pro Survey
If you receive an error stating that your connection is invalid or there's a problem with the flow's trigger, you must: Open Power Automate. In the left pane, select Data > Connections. Search for the Microsoft Forms Pro connection and delete it. Note If you have created multiple connections for Microsoft Forms Pro, you must delete all of them. Select New connection to create a new connection. From the list of connections, search for Microsoft Forms Pro and select it. In the confirmation window, select Create, and then enter your credentials. Open the flow in which the error occurred. Go to the action causing the error. The connection you created is displayed. Select the connection from the list. The error will be resolved after selecting the connection, and the flow will work fine.2KViews0likes1CommentRe: How do I create an Event that all staff members see in their outlook calendar?
Creating events and appointments is easy, but you can work smarter by configuring the calendar to fit your schedule and routine. There are three major components you can configure: the work week, the work day, and the time scale interval. By default, the work week is Monday through Friday; the work day extends from 8am to 5pm; and the first calendar day of the week is Sunday. While these options are adequate for many, they won't suit everyone. If you don't work a traditional work week, you'll want to reset the work week options as follows: Click the File tab and choose Options. (In Outlook 2003 and 2007, choose Options from the Tools menu to find these settings.) In the left pane, select Calendar. In the Work Time section, change the options accordingly. In Figure C, you can see that I changed the Start Time to 9am and that I work a four-day week from Tuesday through Friday. (Nice work if you can get it.) Click OK.2.6KViews0likes1CommentRe: JSON List view format doesn't load all items
I struggled with this, also. I finally got it to work after I did the following: Changed List Settings -> Advanced settings -> List experience to 'New experience'... I don't know if it works in 'Default experience set by my administrator' or 'Classic experience'. Created a new List View... the column customizations didn't show up in the default 'All Items' view.2.7KViews0likes3CommentsRe: Need to convert a text file to Excel - not the typical comma delineated file
You can import data from a text file into an existing worksheet. On the Data tab, in the Get & Transform Data group, click From Text/CSV. In the Import Data dialog box, locate and double-click the text file that you want to import, and click Import. In the preview dialog box, you have several options: Select Load if you want to load the data directly to a new worksheet. Alternatively, select Load to if you want to load the data to a table, PivotTable/PivotChart, an existing/new Excel worksheet, or simply create a connection. You also have the choice of adding your data to the Data Model. Select Transform Data if you want to load the data to Power Query, and edit it before bringing it to Excel.9.2KViews0likes8CommentsRe: Windows Mail App does not work with Gmail accounts
I suggest you open the mail app. Click on the Gmail account and right-click on the account and select account settings. You need to click on mail change mailbox sync settings and make sure that the email sync option is checked. If the issue still persists, let's try the below methods and check if it helps to resolve the issue. Method 1: I would suggest you run the Troubleshooter for Windows App and see if it helps to resolve the issue. Windows 10 Apps troubleshooter: http://windows.microsoft.com/en-us/windows-10/run-the-troubleshooter-for-windows-apps Method 2: If the issue persists, then I suggest you remove and re-configure the account in the Mail app and check. Configuring the account should force it to sync the mails. For reference: Mail app for Windows: https://support.office.com/en-in/article/Mail-and-Calendar-apps-for-Windows-10-Help-cc72af58-c630-43a5-8d75-bcae851565f3290KViews0likes3CommentsRe: how do you remove the share screen bar on teams calls?
The taskbar auto hides when you move the mouse outside of the sharing screen for a while. There’s a catch though: the second you move the mouse, the taskbar reappears. On top of that, when using third party screenshot apps, you need to move your mouse back onto the window of choice before clicking to capture the screenshot. When doing this, the taskbar reappears. Finally, Auto-hide doesn’t work adequately on multiple occasions. Users move their mouse down to the video feed or even completely outside the window, keep it still for several seconds, but the control bar sometimes remains on screen and blocks view.179KViews0likes2CommentsRe: Microsoft Teams Phone System and Virtual Licenses Issue
Sign in to the Microsoft 365 admin center. Go to Billing > Purchase services > Add-ons Scroll to the end to find the Microsoft 365 Phone System – Virtual User license. Select Buy now. Note: Keep in mind you must still Buy the license even though it has a cost of zero. Change an existing resource account to use a Microsoft 365 Phone System – Virtual User license If you decide to switch the license on your resource account from a Phone System license to a Microsoft 365 Phone System – Virtual User license23KViews0likes0CommentsRe: Excell Quick Question Function Large Exponents Precise Numbers ' Function Error?
In some cases, you may be able to prevent rounding errors from affecting your work by using the **Precision as displayed **option. This option forces the value of each number in the worksheet to be the displayed value. To turn on this option, follow these steps. On the File menu, click Options, and then click the Advanced category. In the When calculating this workbook section, select the workbook that you want, and then select the Set precision as displayed check box. For example, if you choose a number format that shows two decimal places, and then you turn on the Precision as displayed option, all accuracy beyond two decimal places is lost when you save your workbook. This option affects the active workbook including all worksheets. You cannot undo this option and recover the lost data. We recommend that you save your workbook before you enable this option. Repeating binary numbers and calculations that have near-zero results Another confusing problem that affects the storage of floating point numbers in binary format is that some numbers that are finite, non-repeating numbers in decimal base 10, are infinite, repeating numbers in binary. The most common example of this is the value 0.1 and its variations. Although these numbers can be represented perfectly in base 10, the same number in binary format becomes the following repeating binary number when it is stored in the mantissa: 000110011001100110011 (and so on) The IEEE 754 specification makes no special allowance for any number. It stores what it can in the mantissa and truncates the rest. This results in an error of about -2.8E-17, or 0.000000000000000028 when it is stored. Even common decimal fractions, such as decimal 0.0001, cannot be represented exactly in binary. (0.0001 is a repeating binary fraction that has a period of 104 bits). This is similar to why the fraction 1/3 cannot be exactly represented in decimal (a repeating 0.33333333333333333333).2.2KViews0likes1CommentRe: Having problem adding secondary axis to excel chart
If your chart has two or more data series, only then you will have the option to select one of the data series and use the Format Data Series to plot the selected data series on a secondary axis. If your chart has only one data series, the secondary axis option is disabled.16KViews0likes0CommentsRe: Warn before sending emails to list of untrusted domains
To get your mail server's IP address: Type cmd on the Start menu to open a Command Prompt. Type ping mail.yourservername.com to find your IP address and the host's server name. check the IP using command prompt If the server name in the ping results matches the name on the certificate, use it as the mail server name in Outlook. If the name is different, ping the server name used in the certificate. If the IP address matches your mail server's IP address use it as the mail server name in Outlook.2.5KViews0likes0CommentsRe: Guest chat in Teams
Configure guest access in the Teams admin center Sign in to the Microsoft Teams admin center. Select Org-wide settings > Guest access. Set Allow guest access in Microsoft Teams to On. Under Calling, Meeting, and Messaging, select On or Off for each capability, depending on what you want to allow for guest users.6.2KViews0likes2CommentsRe: MS Teams crashes *sometimes* during Video calls/meetings
Microsoft Teams crashing during a conference call and screen sharing. ... Go to Users\YOUR_USER\AppData\Local\Microsoft and delete Teams and Teams[Something]Addon. Go to Users\YOUR_USER\AppData\Roaming\Microsoft and delete Teams. Re-install Teams38KViews0likes1Comment
Recent Blog Articles
No content to show