“…Can GroupMail Link to my ACT Database?”

 

Using the GroupMail Business Edition you can link directly to your ACT Database (ACT! version 2010 and above).

Please note, that Sage, the developers of the ACT Database, only allow for ‘read only’ access when connecting; but you will still be able to see the external ACT! data in your GroupMail Group and send an email to your ACT contacts without importing them into GroupMail.

To create the Connection, create an new Group and choose to link it to an External Database.

Linking to an ACT Database from GroupMail

Click on New to Create a New Database Connection and then specify a Name  (any name will do) and click on the “Wizard” button.

Linking to an ACT Database from GroupMail

Choose “ACT! OLE DB Provider for Reporting 2.0″ from the list and click on Next.

Linking to an ACT Database from GroupMail

You can now browse to the location of your ACT Database to select it. Enter in your UserName and Password if you use one and then click on “Text Connection” to verify the connection works, then click OK.

Linking to an ACT Database from GroupMail

Once you have confirmed that the “Test Connection” is successful, then you can proceed by clicking Ok.  All that left is to complete creating your Group which will link to this ACT Database. You can enter in a SQL query to show the data in the table that contains your recipient data.  Click on the blue [SQL] below.

Linking to an ACT Database from GroupMail

Type in the following SQL query:    Select * From CONTACT

(Where “CONTACT” is the name of the table in your database that contains your recipients data.  If you store you recipient data in a different table then modify the SQL query to suit.

Click OK and then “Next”.

Linking to an ACT Database from GroupMail

On the drop down simply choose the field in your ACT Database that contains your recipients Email address.

Linking to an ACT Database from GroupMail

All that’s left to do is give your GroupMail Group a Name and then click on “Create”.

Linking to an ACT Database from GroupMail

Congratulations ! You now have a GroupMail Group connecting directly to your ACT database.

As always, if you have any questions or need some help along the way, don’t hesitate to contact our technical support team


Interested? Download our GroupMail email newsletter software today.

Comments are closed.