Category: Microsoft Office

Using Exchange Server as Internal Relay

IT Problem You want to allow another internal server to send email through your exchange server, either exchange 2007 or exchange 2010. Sometimes people need to for backups, allowing your backup server to email admins with a backup report. Or maybe an internal sql server sending reports to people.   IT Solution This is fairly […]

How to Do Word Mail Merge with Excel Spreadsheet

Word Excel Merge

With Microsoft office, you can easily integrate data from an Excel Spreadsheet into a Word document or an email through Word. In Word, open a new document. Click Mailings > Start Mail Merge, and then click the kind of merge you want to run. Click Select Recipients > Use Existing List. Browse to your Excel […]

Scan Directly From Word 2013

Scan to Word icon

Microsoft Office 2013 is shipped with new features, but some users are missing usability. For instance, a simple button to scan directly from Word 2013 is missing. Also old solutions won’t work anymore. Therefore I’ve developed a solution, to add a scan option to Word 2013. How it Works The following instructions will show you […]

How to Set Up a New Outlook Profile for Exchange in Outlook 2013

Echange 2013 Icon

This article describes how to set up a New outlook profile for exchange in Outlook 2013.  An Outlook Profile  collection of settings that connect your computer to the Exchange server.  The creation of a new profile provides a “fresh start” opportunity that can help solve nagging problems, which may be the result of a corrupt profile.  An Outlook […]

Macro to Insert Rows in Excel Based on a Value

Excel Macro

Conditional formatting in Excel can do many things. But if you need to take action on certain conditions, like if you need to Insert rows in excel based on a value, you will have to do that in a macro.  This can seem a little tricky at first if you aren’t used to writing macros, […]

Running Outlook Command Line Switches Using a Desktop Shortcut

Outlook Icon

Outlook offers a substantial number of command line switches to maintain, correct, or change the behavior of Outlook. There are several ways to run Outlook with a command line switch. Creating a shortcut allows you to do it without leaving your Windows desktop. Right click on your desktop background and select new>shortcut. Then, for the […]

User Profile Folders for Microsoft Office 2007 and Microsoft Office 2010

User Profile Folders for Microsoft Office 2007 and Microsoft Office 2010 Following are the folders created during a Microsoft Office 2007 or 2010 Installation that are usually not removed with an uninstall from the control panel. If you are re-installing, and have a problem, you should remove these folders before attempting the installation again. C:Users[User]AppDataRoamingMicrosoftTemplates […]

Add pictures to Word Mail Merge with Office

The key to accomplishing this with word is to name the files in a way that Word can treat them as discreet data. To do this requires that the pictures be named something that matches one of the database fields – for example, last name. They must also be in one folder that is accessible […]