Hello,
I am trying to send an email of multiple records with Alpha5 v9.
The email I am trying to send, would contain field data from multiple records within the same table all that share the same email address.
Ex.
Fields: Class, Email, Enrollment, Professor, Author, Title, ISBN, Edition, Copyright
Record1 Data: AEM 3200 , 30 Student, [email protected], Mr.Professor, Suess, Green Eggs & Ham, 3rd, 2010
Record2 Data: AEM 3200, 30 Students, [email protected], Mr.Professor, Tolien, Lord of the Rings, 2nd, 2010
Record 3 Data: AEM 4000, 100 Students [email protected], Mr.Professor, Tolkien, Hobbit, 1st, 2009
So I wanted to click within the browse on the little email icon next to the email field, so alpha5 would open up the email client. I wanted to open a saved template that did the following:
Dear Professor <<Professor|Y>>,
I am touching base regarding your Fall 2012 text requirements.
Could you please confirm or update the information we have speculated for your course(s):
Estimated Course Enrollments:
<<Class|>> - <<Estenroll||5|0>> Students (Loop this to print all classes with the associated email address)
Textbooks For the Course:
<<Class|>> - <<Author|>> -<<Title|>> (Loop this to print all textbooks for each class, While sorting A to Z the classes.)
The only way I have ever got this to work was to add a Child Link to the Parent table in a set (I know bad idea), and link the too one to many off of the email field. This actually did work (other than sorting) but caused many other issues so I had to bail on that idea.
Does anyone have a suggestion on a way to make this work?
The actual idea is to take all the data in the table and put it into an organized email with the click of a button, so someone can go through and quickly send emails without typing in all the data or filters etc.
Ideas would be greatly appreciated even if it is doing it a completely different way. If anyone needs anymore clarification just let me know.
Thanks,
Chris
I am trying to send an email of multiple records with Alpha5 v9.
The email I am trying to send, would contain field data from multiple records within the same table all that share the same email address.
Ex.
Fields: Class, Email, Enrollment, Professor, Author, Title, ISBN, Edition, Copyright
Record1 Data: AEM 3200 , 30 Student, [email protected], Mr.Professor, Suess, Green Eggs & Ham, 3rd, 2010
Record2 Data: AEM 3200, 30 Students, [email protected], Mr.Professor, Tolien, Lord of the Rings, 2nd, 2010
Record 3 Data: AEM 4000, 100 Students [email protected], Mr.Professor, Tolkien, Hobbit, 1st, 2009
So I wanted to click within the browse on the little email icon next to the email field, so alpha5 would open up the email client. I wanted to open a saved template that did the following:
Dear Professor <<Professor|Y>>,
I am touching base regarding your Fall 2012 text requirements.
Could you please confirm or update the information we have speculated for your course(s):
Estimated Course Enrollments:
<<Class|>> - <<Estenroll||5|0>> Students (Loop this to print all classes with the associated email address)
Textbooks For the Course:
<<Class|>> - <<Author|>> -<<Title|>> (Loop this to print all textbooks for each class, While sorting A to Z the classes.)
The only way I have ever got this to work was to add a Child Link to the Parent table in a set (I know bad idea), and link the too one to many off of the email field. This actually did work (other than sorting) but caused many other issues so I had to bail on that idea.
Does anyone have a suggestion on a way to make this work?
The actual idea is to take all the data in the table and put it into an organized email with the click of a button, so someone can go through and quickly send emails without typing in all the data or filters etc.
Ideas would be greatly appreciated even if it is doing it a completely different way. If anyone needs anymore clarification just let me know.
Thanks,
Chris
Comment