If you are all of a sudden missing history items on the History tab in Sage ACT, make sure the filters have not been set to exclude dates or types of histories. The filter section is on the bar that separates the histories from the top Contact view. I myself have done this - clicked on the History Types to only show, for example, emails, and then forgot to set it back. Flummoxed me no end until I went, duh, slapped forehead, and set it back right again.

Boy, times are tough.  Companies are hurting and I’ve been working with a lot of clients recently who are looking for creative ways to find new or keep existing clients.  These clients all have customer databases and are trying to figure out ways to mine the data and go after any low hanging fruit.  They tell me “the phones aren't ringing” and they need to find ways to make that happen.  In the process of helping people run reports and figure out who to

Linkedin is becoming important in the business world.  If you are on Linkedin, you should have a link to your profile on your email signature.  However, the default URL link for a public profile can be rather ugly, with numbers instead of your name or your business name. It’s  easier to point people to your LinkedIn profile with a customized URL  I have tried to create a standard URL for all my social media locations, including Twitter, Linkedin and Wordpress. Here's how

If you use a custom template all the time in Sage ACT, you should add it to your menu dropdown so it's easier to find.  Here's a way to do that. Templates live in the Template folder that is under the database files associated with your master or remote database.  For remote or local databases, these are usually under My documents\ACT\ACT Data\ and then there is a folder called somename-database files. The somename is the name of your remote database. In that folder are other folders

Starting with version 14 of the Sage ACT diagnostics tool, ACTDIAG, you can now run some ACTDIAG commands via a command line interface. Using the server NT scheduler you can then have them set to run on a periodic basis. First off, here's a list of what you can run via command line. Note, you need to run these on the server hosting the database in question.  This data is also on the help file for ACTDIAG, something I don't thank a lot of people actually look at and should.  You can

Starting with ACT version 2012, you can now create some informative Excel pivot tables using what is called a Star schema.  The data goes after histories and opportunities. Two tables are created.  It’s a bit complicated to set up, but once done you can start to do some sophisticated drill downs in Excel to show history records.  Here’s a screen shot of one pivot table I just created. The one below is using the Opportunities table. Here’s what I was able to produce in

This situation can result from the Windows Event Log being full. Resolve this using the following steps to set the Event Log to Overwrite. Solution: 1. Close Sage ACT!. 2. To open Task Manager and press CTRL+SHIFT+ESC and locate Act.Server.Host.exe andClick End Process. 3. Right click on the My Computer icon and select Manage. 4. Expand Event Viewer. 5. Right click on Applications and select Properties. 6. Change Log File setting to Overwrite events as needed. 7. Click OK to apply the change

A customer calls me this week saying they need to create Sage ACT queries and search for up to 600 zipcodes per query. That means entering in the Zipcode query 600+ times.  Wow, that will take a while.  I told him to give me a couple of minutes to dream up something. Here's what I came up with.  I thought I'd share it with everyone in case you have to do this yourself.  It is going to sound a bit complex, but trust me, it isn't really. First off, you may not know this, but