3 Replies Latest reply on Jan 28, 2008 4:53 AM by (jerome_moussalli)

    Send E-mail To Recipients From Recordset Attachment problem

      Hello !

      I got a recordset which stored a list of recipients emails.

      CREATE TABLE IF NOT EXISTS `tasks` (
      `id_task` mediumint(9) NOT NULL auto_increment,
      `id_procedure` mediumint(9) NOT NULL,
      `id_step` mediumint(9) NOT NULL,
      `lib_task` varchar(40) NOT NULL,
      `recipient_email` varchar(80) default NULL, <---------------- email to use
      `email_text` mediumtext,
      `url_document` varchar(100) default NULL, <------------------ name of document to send for THIS recipient as attachement
      PRIMARY KEY (`id_task`),
      KEY `id_procedure` (`id_procedure`),
      KEY `id_step` (`id_step`)
      )

      There's less than 10 records to process.

      Table content :

      RECIPIENT 1 DOCUMENT 1
      RECIPIENT 2 DOCUMENT 2
      RECIPIENT 3 DOCUMENT 3
      RECIPIENT 4 DOCUMENT 4
      RECIPIENT 5 DOCUMENT 5
      RECIPIENT 6 DOCUMENT 6

      I want to use the "Send E-mail to Recipients From Recordset" behaviour and Dynamic Datas.

      The problem is that each recipients are well processed but all of them receive the attach document of the FIRST one !

      Email results :

      RECIPIENT 1 DOCUMENT 1
      RECIPIENT 2 DOCUMENT 1
      RECIPIENT 3 DOCUMENT 1
      RECIPIENT 4 DOCUMENT 1
      RECIPIENT 5 DOCUMENT 1
      RECIPIENT 6 DOCUMENT 1

      How can I fix it ?

      Thanks for your help. Jérôme.