Ben Hamilton

Different ways to use 123 Sync with Act! and MS Exchange

The different ways to use 123 Sync with Act! and MS Exchange.

Posted in ACT! | Tagged , , , | Comments Off on Different ways to use 123 Sync with Act! and MS Exchange

Excel formula to convert minutes into Hours and Minutes

On occasion I end up with an Excel spreadsheet that has a list of items, each of which has a duration. It’s easy to sum up the minutes and get a total number of minutes (see B7 in the picture below). But it would be nice to see that in “x hours y minutes.” don’t […]

Posted in How to | Tagged , , | Comments Off on Excel formula to convert minutes into Hours and Minutes

Editing Microsoft Office Documents on the iPad

I got asked on the weekend about what do I use on the iPad to edit Microsoft documents. I’ve been using an iPad (the ‘new iPad’ or the ‘iPad 3’ depending on who you talk to) and have been needing to both create and edit Microsoft Office Word and Excel documents. I’ve tried using Google […]

Posted in How to, Microsoft | Tagged , , , | Comments Off on Editing Microsoft Office Documents on the iPad

The Perils of Updates

…and hell broke loose. Every app on the machine, every little bit of system code wanted to update itself. Not only did it waste a ton of my time supervising all this updating, I could never be sure when it was finished. After updating a lot of stuff didn’t run anymore…

Posted in General | Tagged , , | Comments Off on The Perils of Updates

What Version of Microsoft Installer?

Sage ACT! 2011 and 2012 require Microsoft Installer 4.5 or better to be installed. I like to know prior to running the Sage ACT! installer just which version is installed as the Sage ACT! installer will install it if it’s required and then do a reboot. And we all know that reboots are often not […]

Posted in ACT! | Tagged , , | Comments Off on What Version of Microsoft Installer?

Best Practice Outlook 2010

Good read, if you’re into tech stuff: This guide represents our advice on how to get the most out of Outlook 2010. However, it is not a comprehensive guide. A few core scenarios are covered to help you leverage Outlook into your information management needs. Best practices for Outlook 2010 – Outlook – Office.com.

Posted in Microsoft | Tagged , , | Comments Off on Best Practice Outlook 2010

No IMAP to Exchange 2003

So I ran into an issue I’ve not seen before yesterday. Couldn’t get Microsoft Outlook 2010 configured to talk via IMAP to Microsoft Exchange 2003, although the username and password was correct, it just would not connect. Turns out the answer is in this Microsoft KB article: Users Cannot Log On Using POP3 and the […]

Posted in Microsoft | Tagged , , | Comments Off on No IMAP to Exchange 2003

Update on XPUnlimited

So some time ago I wrote a post about using XPUnlimited questioning it’s legality. Today I’ve had another systems engineer tell me that it is legal. So I’ve spoken with the local distributor (http://xpunlimited.com.au/) here in Australia and asked them to clarify this. Part of their reply pointed me to the FAQ on the XPUnlimited.com […]

Posted in Microsoft | Tagged , , | Comments Off on Update on XPUnlimited

Export ACT! reports to Excel

Had a client today need some information out of ACT!, and ideally it would be in an Microsoft Excel spread sheet. Given that one of the default ACT! reports gave the bare minimum required (Group Membership) we spent some considerable time editing a copy of that report to display the actual fields we wanted, both […]

Posted in ACT! | Tagged , , , | Comments Off on Export ACT! reports to Excel

Who should pay for Microsoft SQL installations that go wrong?

The day is almost over, so I’ll fill you in on some of what occurred today, as it relates directly to this post by Mike at GLComputing. This was originally written as a comment to his post and kinda grew, so I’m posting it here in full. SQL 2008 Express R2 has finally let me […]

Posted in ACT!, Microsoft, SQL | Tagged , , , | 1 Comment

How to clear the MS Exchange mail queue quickly

Spent the day dealing with an exchange server that had been compromised. As a result, heaps of spam emails were in the exchange mail queue. Manually removing them is a major pain in the rear. Fortunately, others have shared how to clear the Microsoft Exchange mail queue of thousands for spam mails. Stop the SMTP […]

Posted in How to, Microsoft | Tagged , , , | Comments Off on How to clear the MS Exchange mail queue quickly

Is using XP Unlimted legal?

This is a question I’ve been asked, and I’ve seen a multitude of opinions out there on the wild wild web. Thus I thought I’d share my findings. First of all, what is XP Unlimited? XP Unlimited turns your Windows System into a full blown Terminal Server, without any limit. XP Unlimited gives you eXtra […]

Posted in Microsoft | Tagged , , , | 1 Comment

How to: Clear Outlook Location list

Had an issue yesterday where we wanted to remove some entires from Outlooks location list. Huh? When you book an appointment in Microsoft Outlooks calendar you can specify a location. If ACT! by Sage has a Resource that is designated as a location, when ACT! sync’s with Outlook that location list gets filled in. So, […]

Posted in How to | Tagged , , , , , | Comments Off on How to: Clear Outlook Location list

How to: discover open files on Microsoft Server

So you’re working on a Microsoft Server machine, merrily getting stuff done, when you get a message saying that it can’t continue because files are open. Sound familiar? It happens to me often. Here is how I find out which files are open and who has them open: If you’re working on a Microsoft Server […]

Posted in How to | Tagged , , , , , | 1 Comment

Command line terminal server

I’ve just come across a terminal server that wouldn’t let me log on. Turns out the maximum number of users the terminal server is licensed for has been exceeded. Thusly, from another machine on the network, we open a command prompt and type qwinsta /server:<servername> This will give a list of the terminal server sessions […]

Posted in General | Tagged , , , | Comments Off on Command line terminal server

Turn off Enhanced Security

Just had need of this article, method #2 describes how to turn of Microsoft Internet Explorer Enhanced Security Configuration.

Posted in How to, Windows | Tagged , , , | Comments Off on Turn off Enhanced Security

Network Connection control panel applet

Quick tip on getting the Network Connections control panel applet, do one of the following: WIN+R, ncpa.cpl<enter> CTRL-SHIFT-ESC, Applications, File, New Task, ncpa.cpl <enter> This will give you quick access to changing network settings, useful if you have no mouse… as per a workstation I’m working on right now.

Posted in How to, Microsoft | Tagged , , , | Comments Off on Network Connection control panel applet

When SharePoint barfs

A client has a SharePoint installation that has died, with all their project files and data in it. In the course of searching for how to resurrect it, I’ve found the following that seem to be things that others may well benefit from: An article on the Official SBS Blog, pointing to an unofficial tool: […]

Posted in How to, Microsoft | Tagged , , , , | Comments Off on When SharePoint barfs

Evolving the ACT

It is now two weeks in to my new digs at Evolution Marketing – and it sure is fun. Primarily I’ve been learning how to drive ACT!, software to take care of your contact management. Yesterday and today I’ve been playing with custom tables in the ACT! MS-SQL database. While ACT! looks after contacts and […]

Posted in ACT!, General, Microsoft, SQL | Tagged , , , , , , , , , | Comments Off on Evolving the ACT

Port Listening

If like me you need to test if network traffic is getting through a firewall then this tool will be of use to you as well. You run it on the target/client system, specify which port you want it to listen on, a response message and click on listen. Able to listen on multiple ports […]

Posted in How to, Microsoft | Tagged , , | Comments Off on Port Listening