How Create a Mail Merge in Word from ACT Lookup

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?

Re: How Create a Mail Merge in Word from ACT Lookup

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?

Re: How Create a Mail Merge in Word from ACT Lookup

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.

Re: How Create a Mail Merge in Word from ACT Lookup

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.

Re: How Create a Mail Merge in Word from ACT Lookup

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.