Automatically sending emails x days before a custom date....

[aaelghat]

Hi, I run a business where people sign-up for subscriptions. I have a date field in Contacts where I record the subscription stop date, and what I'd like to do is every day have a job that runs that would send out an email 10 days before the subscription stop date (e.g. if stop date is Feb 5th, have the email go out around Jan 26th).

How would I go about doing this? Thanks in advance.

[andopes]

Hi aaelghat

You need to do the following:

1. Create a script into Contacts module modules/Contacts/AlertSubscirption.php containing the code to send an email warning the upcoming subscription end date;
2. Edit the file modules/Schedulers/_AddJobsHere.php adding a new entry into array $job_strings and a new function whose name is the entry itself. Take a look at the function "runMassEmailCampaign", basically you need to include the script containing the code;
3. Go to Admin -> Schedulers and add a new scheduler selecting your new task;
4. Make sure your cron contains an entry for triggering the SugarCRM installation.

Cheers