Customer email lists

[Mostly Baffled]

Hi,

I'm trying to mail out a feedback questionnaire to a broad selection of our customers (those recorded in Actinic as having purchased from us) and would like to build a list of customer emails from Actinic 7.

Just wondered if there is a quicker way of doing this other than cutting and pasting individually from each order profile?

Any help greatfully received.

[Duncan Rounding]

You can get this information from the database with Access or Excel.
If you use Excel you can go to Data - Import External Data - Import Data - select the Actinic database and the table Person. You may just have to delete some entries that appear more than once.

[Jan]

You can export them from the database using access or excel and then use something like groupmail to remove the duplicates. They are stored in the table called person.

We also sell a plugin for V7 that will do this for you, there are more details and a free trial at this URL :

http://www.mole-end.biz/acatalog/One...or_Actnic.html

Regards,

[Mostly Baffled]

Thanks a lot guys. I think on the basis that mole-end hasn't failed me yet I'll go for that option.

One more question though - how do I do it?

[Jan]

Just install the free trial from the URL above, setup the details on the front page to have no dates, selected and set the order types you want to export, enter the name of the file you want to save them into and click on export. If you want to print labels or envelopes, click on preview instead of printing and then select print on the preview page that is displayed.

The trial version is limited to exporting 50 at a time but the full version will deal with all of them at once.

Regards,

[Mostly Baffled]

Thanks again Jan,

I'll give it a go.

[kernelpower_Ltd]

You can get this information from the database with Access or Excel.
If you use Excel you can go to Data - Import External Data - Import Data - select the Actinic database and the table Person. You may just have to delete some entries that appear more than once.

Sorry can you expand on this , I open the enu from excel but then I am unsure what to look for in the actinic directory , which folder is it in and what is the file called??

Any help much appreciated.

[kernelpower_Ltd]

Backup well before doing anything.

The v7 Actinic database can be found here:
C:\Program Files\Actinic v7\Sites\Site1
The file is called:
ActinicCatalog.mdb

damn your good , thanks for the quick advice!!! wil backup twice then give it a go.

[kernelpower_Ltd]

got it done , thanks again for your help , much appreciated.

[Duncan Rounding]

What's your Actinic site URL kernelpower?