milldataanalyst
Programmer
Hello -
We are having an issue with an event that was created by someone that has left the company. All the IT people on my team are new to Exact Event Manager (< 1 year) and we do not know all the ins and outs of it.
So, my problem is this. I have an event that is set up to break on the customer number and send an email to the email address field. The SQL statement returns multiple rows per customer number but only one of the lines is being sent in the email.
I have checked the following:
[li]The query results return more than one row for the customer I am testing with. Note that the person that developed the query used the different tabs to develop the query and did not write the SQL themselves. With the events I have developed, I tend to write the SQL myself and mine are working. I doubt that it matters, but I thought I would mention it.[/li]
[li]On the email tab, the message text has the Begin Repeat and End Repeat tags. I even took an event that was working and checked to see if there was some difference the the way the tags were handled and I didn't see any. So, it looks like the tags are correct.[/li]
[li]On the Subscribers tab and Advanced sub-tab, the Message Break Field is set to the cus_no (now no distribution method is checked to the right but on some other events I see the same thing and they work).[/li]
[li]On the Subscribers tab and Advanced sub-tab, the Contains Email Address to send to value is set to the email_addr.[/li]
Does anyone have any ideas what we are doing wrong? If more information is needed, please let me know what you need to know.
Thank you.
Tammy
We are having an issue with an event that was created by someone that has left the company. All the IT people on my team are new to Exact Event Manager (< 1 year) and we do not know all the ins and outs of it.
So, my problem is this. I have an event that is set up to break on the customer number and send an email to the email address field. The SQL statement returns multiple rows per customer number but only one of the lines is being sent in the email.
I have checked the following:
[li]The query results return more than one row for the customer I am testing with. Note that the person that developed the query used the different tabs to develop the query and did not write the SQL themselves. With the events I have developed, I tend to write the SQL myself and mine are working. I doubt that it matters, but I thought I would mention it.[/li]
[li]On the email tab, the message text has the Begin Repeat and End Repeat tags. I even took an event that was working and checked to see if there was some difference the the way the tags were handled and I didn't see any. So, it looks like the tags are correct.[/li]
[li]On the Subscribers tab and Advanced sub-tab, the Message Break Field is set to the cus_no (now no distribution method is checked to the right but on some other events I see the same thing and they work).[/li]
[li]On the Subscribers tab and Advanced sub-tab, the Contains Email Address to send to value is set to the email_addr.[/li]
Does anyone have any ideas what we are doing wrong? If more information is needed, please let me know what you need to know.
Thank you.
Tammy