3 Microsoft Excel tips to master

3 Microsoft Excel tips to master

Every computer user must be well-versed in various office programs, including Microsoft Excel. If you only know a few basic commands, you haven’t fully mastered Excel. Here are a few features that can make your life easier. Pie and Sunburst Charts Everyone knows that bombarding stakeholders with endless numbers and decimal points is the wrong […]

Security tips for Office 365 migration

Security tips for Office 365 migration

Making the decision to migrate from an on-site system to a cloud-based Office 365 is easy, but the migration process itself presents numerous security challenges. By covering these essentials, you’ll minimize security breaches and ensure you can enjoy the benefits of Office 365. Identify your company’s sensitive data… Most files housed within your servers contain […]

Using Access and Outlook to Send To Mailing Lists

Perhaps the most popular article on the site explains how to send email to a bunch of people using Access and Outlook.

It has garnered its fair share of comments and emails, and one came in today that I figured I'd share and then elaborate on.

The mail reads (in part):

I have a following question: How to modify this module to be able to send messages to various mailing lists that I predefine in respective queries? In other words, I have in my database 3 categories of customers (in 3 different queries) andI want to address them with a different message.

Read more 20 Comments

Importing and Exporting Mail and User Accounts in Outlook 2007

Outlook 2007 did away with the export account information that was present in earlier editions. So, if a user with one account moves machines, it's often faster to just recreate the account on the new machine. However, if a user has 8 accounts (like one did today) it's time to find a better way.

Read more 66 Comments

Our Favorite Tools: Google Calendar

Not only am I a sysadmin, but I'm also a family man. I've spoken of my love for the Exchange connector which syncs my Treo with my Outlook calendar; but that doesn't help my wife who would like to know where I am too...

Enter Google Calendar.

Both my wife and I have Google acounts which allows us to share our calendars.

Outlook Deleted Items Recovery

At one of my clients, we limit their users mailboxes to keep the Exchange server humming along. We use an archiving program to keep older mail around in accordance with our document retention policies.

One of the things we mandate is that Outlook purges its Deleted Items folder upon closing.

Handy Word Tip – Tracking Changes by User

A few versions ago, MS Word came under fire for including personal information with every document. The registered user's name, company and other info was available in the metadata of the document.

MS answered the hue and cry by giving users the option of removing this personal information.

How to Send E-Mail From MS Access using Outlook

Click here for the changelog. (I moved it to the bottom of the page.)

Microsoft Office is designed to work together in an effort to help users get their work done more efficiently. To this end, Microsoft has given all the pieces of the Office suite the ability to control or be controlled by other of its Office siblings through the use of Visual Basic for Applications.

Read more 239 Comments