• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

danblee.com

Tutorials & Knowledge Base Articles for System Administrators who wear many, many hats.

  • Home
  • About
  • Ask Me
  • DBLHost.com
You are here: Home / Archives for Microsoft Office

Microsoft Office

Powershell script won’t run portion requiring Excel in Scheduled Task

September 26, 2019 by Dan B. Lee Leave a Comment

Some of the scripting I've recently done requires Excel to be launched (non interactively) on a domain controller to gather usernames and whatnot. For some reason, the entire script would work perfectly besides the portion that requires Excel. I could run the script as an admin in ISE and it would work, but not via the Task Scheduler. Here's the fix: Create these two folders on your server: C:\Windows\System32\config\systemprofile\Desktop … [Read more...] about Powershell script won’t run portion requiring Excel in Scheduled Task

Filed Under: Microsoft Excel, Microsoft Office, PowerShell Tagged With: Excel, PowerShell, Scripting, Task Scheduler

Tools for Testing SMTP, DNS, other mail server types, and more

August 16, 2017 by Dan B. Lee Leave a Comment

Here's a great tool for testing DNS, Mail, SMTP, and similar environments to see if they are listening on certain ports across the internet. https://www.dnswonder.com/Tools/ With it, you can test: GET DNS RECORDS GET MX RECORDS GET PTR RECORDS GET SPF RECORDS GET BLACKHOLE LIST (RBL) GET SMTP SERVER TYPE TEST SMTP CONNECTIVITY TEST EMAIL DELIVERY TEST EXCHANGE SERVER TEST IMAP SERVER TEST ZIMBRA SERVER TEST REGULAR EXPRESSION ENCRYPT DATA Enjoy. … [Read more...] about Tools for Testing SMTP, DNS, other mail server types, and more

Filed Under: Exchange 2003, Exchange 2010, Exchange 2013, Microsoft Outlook, Office 365, Security, Windows Server 2003 Tagged With: DNS, Exchange, Mail, SMTP, Testing

PowerShell – Export Enabled Users and other Data from Active Directory

March 7, 2017 by Dan B. Lee 1 Comment

I made a script that does a few things: Gets all users that are enabled Creates a table, listing all the the users with a few account details I want Export the table to a .csv file with a unique name, appending the date the export happens Here's the whole thing. I'll explain what it does at the bottom: Import-Module ActiveDirectory # All of the properties you'd like to pull from Get-ADUser $properties=@( 'displayname', 'lastlogondate', 'passwordneverexpires', … [Read more...] about PowerShell – Export Enabled Users and other Data from Active Directory

Filed Under: Microsoft Excel, Microsoft Windows, PowerShell, Uncategorized Tagged With: Active Directory, CMDlet, Get-User, Last Logon, Password Set To Expire, PowerShell, Scripting

Narrow down your searches in Outlook: A helpful guide.

April 2, 2015 by Dan B. Lee Leave a Comment

I came across these and immediately had to reference them here for myself as well as for the sake of others who I know will benefit from them. From Outlook's website here: https://support.office.com/en-nz/article/Learn-to-narrow-your-search-criteria-for-better-searches-in-Outlook-d824d1e9-a255-4c8a-8553-276fb895a8da Type this To find this bobby Items containing bobby, BOBBY, BoBby, or any other combination of uppercase and lowercase letters. Instant Search is not case … [Read more...] about Narrow down your searches in Outlook: A helpful guide.

Filed Under: Microsoft Office, Microsoft Outlook, Uncategorized Tagged With: Indexing, Microsoft, Microsoft Outlook, Outlook, Searching

The Server Responded 550 Access Denied – Invalid HELO Name See RFC 2821 4.1.1.1

March 9, 2014 by Dan B. Lee Leave a Comment

I was getting this error and quickly found a solution, but I wanted to share this with folks, should they also get the error. If you're setting up an IMAP account, the first step will be to create the account, the next step will be to verify the settings. The verification will work, but the test email will fail, throwing this error: The Server Responded 550 Access Denied – Invalid HELO Name See RFC 2821 4.1.1.1   To fix this, make sure you're using SMTP. Here's how: When … [Read more...] about The Server Responded 550 Access Denied – Invalid HELO Name See RFC 2821 4.1.1.1

Filed Under: Microsoft Outlook Tagged With: cPanel, Outlook

Exchange, Sharepoint, Project, and Office 2013 SP1 Download Available

February 25, 2014 by Dan B. Lee 1 Comment

First things first. Here's where you can download everything: Office 2013 SP1 32-bit Office 2013 SP1 64-bit Exchange 2013 SP1 Project 2013 Server SP1 The Service Pack has been long awaited and long expected. I posted about the Service Pack when Microsoft blogged about it, then followed up again recently with notice that it still hadn't released yet, even though "early 2014" was running out. ZDNet was on top of the details regarding Outlook and Sharepoint Updates. Here's a list of … [Read more...] about Exchange, Sharepoint, Project, and Office 2013 SP1 Download Available

Filed Under: Exchange 2013, Microsoft Office, Windows Server 2012 Tagged With: Exchange, Outlook, Project, Sharepoint

Lync: We’re sorry, but Outlook has run into an error that is preventing it from working correctly.

February 13, 2014 by Dan B. Lee 4 Comments

Here's how to fix an Outlook 2013 error you'll get after installing Lync: Was your install from the streamed install? Yeah, for some reason that stream isn't going to work for some versions of Outlook 2013. Install this version instead: (32-bit): http://www.microsoft.com/en-us/download/details.aspx?id=35451 (64-bit): http://www.microsoft.com/en-us/download/details.aspx?id=35450 That's all. I noticed this error after we created some Office 365 accounts and started using … [Read more...] about Lync: We’re sorry, but Outlook has run into an error that is preventing it from working correctly.

Filed Under: Lync Tagged With: Chat Software, Lync, Microsoft, Microsoft Office, Office 2013

Microsoft to Release Outlook, Sharepoint, and Exchange 2013 SP1 in Early 2014

January 6, 2014 by Dan B. Lee 2 Comments

UPDATE (3/4/2014): It's here! It's finally here! Links to downloads and KB's can be found here: http://danblee.com/exchange-sharepoint-project-and-office-2013-sp1-download-available/   UPDATE: No news, not so good news? There is still no set date for the release of SP1 just yet. "Early 2014" is still the best we've heard at this point. My latest post doesn't give much of an update. I'll be sure and keep the world posted. Microsoft announced the release of Service Pack 1 (SP1) for … [Read more...] about Microsoft to Release Outlook, Sharepoint, and Exchange 2013 SP1 in Early 2014

Filed Under: Exchange 2013, Microsoft Outlook, Sharepoint Tagged With: Exchange, Outlook, Service Packs, Sharepoint

Exchange 2013 RPC Client Access Service keeps restarting

December 19, 2013 by Dan B. Lee Leave a Comment

UPDATE: After SP1, this issue is gone, and all services can be run normally. There's a good chance this issue was fixed at CU3 as I'm seeing user feedback in posts I was following claim that CU3 fixed the problem. Either way, life is better on SP1. This issue looks to be specific to Microsoft Exchange 2013 CU1. My environment is running Server 2008 R2 on a Server 2008 R2 Domain Level. At the time of this post, there is no telling if CU2 fixes the issue. Issue: Here's what you'll see in … [Read more...] about Exchange 2013 RPC Client Access Service keeps restarting

Filed Under: Exchange 2013, Microsoft Outlook, Windows Server 2008 R2 Tagged With: Exchange, Exchange 2013, RPC, Services

Exchange 2013: Shared Room Calendar Setup

December 5, 2013 by Dan B. Lee Leave a Comment

Note: Some of these commands are specific to CU1 in Exchange 2013. Please make sure you have updated to CU1 before continuing: There are few things an administrator wants to take care of right when they begin to create shared room calendars. Here's my workflow for setting up Calendars in Exchange 2013. You'll see that some of the settings aren't different from Outlook 2010. Create the Distribution Group and assign it the role of Room List Add Calendar (Mailbox) to Room List Give Admin … [Read more...] about Exchange 2013: Shared Room Calendar Setup

Filed Under: Active Directory, Exchange 2013, Microsoft Office, Microsoft Outlook, Microsoft Windows, PowerShell, Windows Server Tagged With: Active Directory, ECP, Exchange, Exchange Management, Permissions, PowerShell

Next Page »

Primary Sidebar

Categories

  • Active Directory
    • Group Policy
  • Adobe Photoshop
  • Browsers
    • Chrome
  • Cloud Based Technology
    • Citrix XenApp
  • ConnectWise
    • LabTech
  • Dell
  • Internet Service Providers (ISPs)
  • iPhone
  • Linux
    • CentOS
    • OpenVPN
    • SaltStack
    • Ubuntu
  • Microsoft Office
    • Lync
    • Microsoft Excel
    • Microsoft Outlook
    • Microsoft Word
  • Microsoft Windows
    • Active Directory
    • PowerShell
    • Windows 7
    • Windows 8 Preview & Release
  • Networks
  • News
  • Off Topic
  • Office 365
  • Peripherals
    • Monitors
  • Printers
    • Local Printers
    • Network Printers
  • Programming
    • Python
  • Riverbed
  • Security
  • Sharepoint
  • Social Media
  • Splunk
  • Storage
  • Switching & Routing
    • Cisco
    • Fortinet
  • Technology Culture
    • Opinion
  • Uncategorized
  • Virtualization
    • VEEAM
    • VMware
  • WAMP
  • Web Hosting
    • WHMCS
  • Website Design
  • Windows Server
    • Exchange 2003
    • Exchange 2010
    • Exchange 2013
    • Microsoft SQL
    • Windows Server 2003
    • Windows Server 2008 R2
    • Windows Server 2012
  • WordPress

Footer

Recent Activity

  • pings on Xerox Phaser 3635MFP Default Admin Username and Password
  • Xerox Phaser 3635MFP Default Admin Username and Password — danblee.com on About Dan B. Lee
  • Estudio Login | LOGINEGG on Toshiba E-Studio Default Administrator Username and Password
  • Estudio Login | LOGINSPENT on Toshiba E-Studio Default Administrator Username and Password
  • Estudio Login | CHARTLOGIN on Toshiba E-Studio Default Administrator Username and Password

Dan Lee

Dan B. Lee works at SyApps, LLC., a Managed Hosting Solutions Firm, as a Senior Network Engineer. Dan has a decade of IT experience and specializes in a number of different disciplines including Virtualization, Web Site Hosting and Design, Network Security, Data Center Architecture, Local and Remote Server Hosting, and Backup & DRS Solutions. Read More…

Links

  • Home
  • About Dan B. Lee
  • Ask Me
  • Privacy Policy

Copyright © 2021 · Genesis Child Theme on Genesis Framework · WordPress · Log in