Patricia Egen Consulting Acquires CRMAddons Product Suite from Northwoods Software. Press release date: June 30, 2015 Chattanooga, TN, and Nashua, NH, June 30, 2015 – Patricia Egen Consulting (PEC) today announced the acquisition of CRMAddons from Northwoods Software Corporation.  CRMAddons is a suite of automation tools compatible with the Act! Contact Manager, owned by Swiftpage Act! LLC. The CRMaddons suite includes Sales Automation Manager, Mail Merge and Web Prospect. Every

Traveling for pleasure is an adventure - traveling for work, well, not always as much of an adventure.  I don't keep a  paper calendar anymore.  It's all on the computer or on my smart phone.  Yet, when I head out on a several day trip, I like to keep a paper copy of my details.  When you are on the road and once again either the GPS or your mapping program on the phone has steered you to a dead end, it is nice to have addresses near by.  Even more so it's good to

The following document is useful if you are setting up ACT and ACT for the Web and need to know how to tell your firewall to show ACT as an exception.  It also documents ports that need to be available. Adding Program Exceptions to Windows Firewall for ACT! and SQL Server Click the Windows Start button, click Control Panel Click Administrative Tools, select Windows Firewall with Advanced Features. Note: You will have to complete the following steps for

If you have an ACT! eMarketing account you know you can send out nice looking email blasts.  But, did you know you can also include attachments such as PDFs. You can upload, edit and store images and documents to use within your edited templates in the Media section.  Items to note are: Upload multiple images and documents at once Store up to 100 images in .jpg, .gif and .png formats Browse the free Stock image library for several provided images Edit images quickly and easily

I work with Excel so often that I forget that things I do all the time and take for granted may not be widely known or used.  Today is yet another example.  While working on a client spreadsheet I did something that made my client exclaim and stop me mid-stream to show him what I had done. We were working on multiple sheets in a workbook - actually it was his Paypal transactions and we were preparing sheets for each month.  He had already started the sheets and I was putting in

Yesterday I was once again reminded of something I read in a book by Dale Carnegie: "91% of customers say they give referrals yet only 11% of salespeople ask for them." One of my clients said they were really happy with what we had done and that they were going to refer us to their business networking group. And I asked myself, "self, when was the last time you asked for a referral?" Quick rap on the forehead, and then a postit note saying "Ask for a Referral" placed on the monitor. Such

I was building a report for a client in Excel using an OLEDB connection to the back end data base.  Pretty standard stuff, do it all the time.  From my favorite SQL Query editor tool all was well.  Snap the SQL Select statement into Excel and all I can get is "Initialization failed" and no data. In fact, attempting to get any data (even just from a single table) from this data base gave the same error message. After some fumbling around I realized that we were connecting to the

We do a lot of spreadsheet reporting against a variety of data environments - for example ACT, Quickbooks, and other SQL vertical applications.  By default, Excel does not automatically refresh the data connections when you open the file.  You need to "turn on" this option.  Note, if the data being imported is a large amount, this will mean it will take longer to open your Excel file - which is why it is turned off by default. Here's what you do to turn it on.