[TYPO3-english] Send email X hours after FE-user sign up? (or delayed emails)

Morten Kjems mortenkjems at gmail.com
Thu Jan 17 19:48:07 CET 2013

Directmail looks interesting.

The receiver list can be dynamically built using a SQL query.

I have never used SQL queries but it should be possible to do something 
like this:

SELECT email
FROM fe_users
WHERE usergroup = 3 AND (crdate >= GETDATE-1day)

This part (crdate >= GETDATE-1day) is wrong for sure and I will need to 
look up how to write it right.

But it should result in a list with all fe-users that belong to group 3 
that signed up during the last 24 hours.

That could work right?

Can anyone recommend directmail?

More information about the TYPO3-english mailing list