12-27-2012 06:21 AM
I posted this on the Sage ACT forum, but realize there is a different one for Sage ACT Premium. I have have Sage Premium Version 11.
I really dislike the ACT word processor and would like to use MS Word to make some labels. If I have a particular lookup in ACT, how can I transfer those contacts into a file that I can use with MS Word's mail merge for labels?
12-27-2012 07:18 AM
12-27-2012 07:55 AM
I have a database containing just the contacts I want to use in the merge. I tried going to Tools->Export to Excel, but "Export to Excel" is greyed out.
What am I doing wrong? Thanks.
12-27-2012 08:14 AM
Ok. I have Sage Act Premium 2009, but Excel 2010. I understand that ACT 2009 doesn't integrate with Excel 2010. Is there any way of still exporting the list to Excel? If not, are there any other formats that will work? I tried the Export Wizard, but it will only let me export to another existing file? Am I missing something?
12-27-2012 09:07 AM
First the label in the ACT! program are printed through the ACT! reports and there are several pre configured labels there, have you checked those out? Bscause you can't use Excel or Word 2010 with ACT! 2009 you will need to expert the data you want to a tab delimited file and then inport that into Excel. Another option is to upgrade to ACT! 2013 so you can connect directly to Office 2010.
12-27-2012 09:53 AM
Yes. For some reason, I couldn't initially Export to a tab delimited file (option didn't come up), but now it does, so problem solved.
WIth all respect to Sage, the reports/templates are terrible, especially if you are doing documents with fields. I still can't find a way to have "city" and "state" automatically one space apart. Having the field manually spaced apart looks terrible. Would much rather manipulate it in Word.
12-27-2012 10:28 AM
The report editor isn't anything like a word processing program, it's actually more like a programming language. For things like concatinating the city state and zip you need to use a program pcript to do that.
There is a third party book with comprehensive training information on the ACT! reports, here is the link.
Full disclusure I wrote the reports chapters of the book. The report chapters work for all version of the ACT! program since ACT! 2007.