Results 1 to 8 of 8

Thread: Scheduling individual newsletters

  1. #1
    plassche is offline Junior Member
    Join Date
    Oct 2007
    Posts
    2

    Default Scheduling individual newsletters

    Dear reader,

    We are a software company, providing trial accounts. What I want to do:
    - 2 days after providing the trial software, I want to send a 1st automated e-mail with "tips & trics"
    - 2 weeks later, I want to send a 2nd automated e-mail with tips & trics
    - at the end of the trial period, I want to send an automated evaluation e-mail

    So, it is not a general mailing, but a set of scheduled e-mails (3 in total) to an individual.

    I am looking forward to your answers.

    Kind regards,

    Rob van de Plassche

  2. #2
    jmertic's Avatar
    jmertic is offline Sugar Community Manager
    Join Date
    Dec 2007
    Posts
    3,996

    Default Re: Scheduling individual newsletters

    Which version of Sugar is this for?
    John Mertic
    Sugar Community Manager

  3. #3
    ashdwi1's Avatar
    ashdwi1 is offline Sugar Community Member
    Join Date
    May 2008
    Location
    Noida
    Posts
    427

    Default Re: Scheduling individual newsletters

    If you are doing with CE version , you need to be good in PHP and MySQL.
    Simply create 3 cron jobs and a seprate module/table for tracking last sent email .
    When a 1st job is run , set an entry into db ,for 2nd job , when 1st job passed on desired period , likewise 3rd job.
    Let me know your questions.
    thanks

  4. #4
    supermarket1 is offline Junior Member
    Join Date
    May 2011
    Posts
    5

    Default Re: Scheduling individual newsletters

    I am using Sugar Pro 6.5.0

  5. #5
    Francescas's Avatar
    Francescas is offline Sugar Community Member
    Join Date
    Dec 2011
    Location
    Colorado
    Posts
    508

    Default Re: Scheduling individual newsletters

    Were you able to find a solution for this scenario?
    Francesca
    =========
    SugarCRM Professional 6.5.15
    Linux
    Apache
    MySql
    PhP

  6. #6
    ramendrasinghrathore@hotmail.com Guest

    Default Re: Scheduling individual newsletters

    Hello

    Let i explain the way in which i will do such type of task may be it will help you.

    1.Create a campaign with three mail template(2 days, 2 weeks later, end of the trial period).
    2.Look up the emailman table in database and understand the it's structure, fields. This will help you to create script.
    3.Create logic only for save new record.

    Now create script which insert record in emailman table.
    Here you will run three insert query
    a.) First query: sent date(this is one field of emailman table) should be two day after the created date,mail template id should be the 2 day template id.
    b.) Second query : Set sent date according your requirement.
    c.) Third query : Set sent date according your requirement.

    This way the mail automatically shot on particular date.

    I explained in short please check the structure of emailman table and make insert query according that.

  7. #7
    ramendrasinghrathore@hotmail.com Guest

    Default Re: Scheduling individual newsletters

    For pro version you can use workflow "After time elapses"

  8. #8
    Francescas's Avatar
    Francescas is offline Sugar Community Member
    Join Date
    Dec 2011
    Location
    Colorado
    Posts
    508

    Default Re: Scheduling individual newsletters

    Quote Originally Posted by ramendrasinghrathore@hotmail.com View Post
    For pro version you can use workflow "After time elapses"

    FYI there is a problem with that workflow in Pro 6.5.11 which does not appear to be fixed yet:
    Open Source Feature Request and Issue Database | SugarCRM.com English (Americas)
    Francesca
    =========
    SugarCRM Professional 6.5.15
    Linux
    Apache
    MySql
    PhP

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Email campaigns: newsletters.
    By DanyC in forum Help
    Replies: 3
    Last Post: 2012-05-29, 02:06 PM
  2. How do I insert images in newsletters
    By omarm in forum Help
    Replies: 3
    Last Post: 2010-05-06, 02:39 PM
  3. Send newsletters
    By lminnozzi in forum Help
    Replies: 0
    Last Post: 2008-12-10, 08:13 AM
  4. Newsletters not working right in 5.0.0
    By sdolesaventech in forum Help
    Replies: 0
    Last Post: 2008-02-04, 03:43 AM
  5. Newsletters with Sugar
    By mpais in forum Help
    Replies: 4
    Last Post: 2007-12-13, 06:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •