Direct Link Actinic - Group Mail

[paulobrad]

Hey,

In group mail there is an option to create a new group based on an external database. I can create a new connection with "Microsoft OLE DB Provider for ODBC Drivers" and "ActinicOriginal7" appears in the data source name list. I guess I use this not catalog, simple shipping etc if I want email adds.

However, all the tables appear empty when I try and get the email addresses. I don't use the full functionality of actinic, orders aren't placed by registered customers - just on the fly.

Any ideas how I can automatically get the addresses updated in group mail - I know about Mole End extentions allready but hoped this would work as it's more dynamic and won't need constant updates with the mole end software.

Cheers.

[Jan]

You need to use ActinicCatalog7 not ActinicOriginal7. You need to link to the Person table.

Regards,

[paulobrad]

Cheers,

When I do that all the fields are blank except ContactID and bKeepContactPrivate.

Any ideas how to get to the email addresses?

Cheers.

[Jan]

That is where the email addresses are stored, you get 2 copies for every order in the catalog.

They are stored as memo fields but I would have thought that would have been a problem.

If you open the database up in acess can you see rows in that table?

Regards.

[paulobrad]

Sorry to sound thick but how do I load in Access ?

Cheers.

[paulobrad]

Ooops, sorry - got it.

Yeah, the "Person" table has everything I need when I view it in Access but it doesn't all appear in Group Mail.

There seems to just be thousands of blank records when I see it in group mail - but the records are complete when I see them in access.

Any ideas?

[paulobrad]

Sorry to be annoying and post again but I just can't seem to get this working.

I select the ActinicCatalog and it imports all my records but except for ContactID and bKeepContactPrivate all the others are blank even though they are completed when I view it in Access.

Cheers for any help.

[Jan]

Which ODBC connection are you using? How many records import?

Regards,

[paulobrad]

YAY! Tried some other ODBC connections and got it going - thankyou!