CDOMAIL - Need to display same variables in sent email twice

[csalzman]

Hi there, wondering if anyone has ever tried to display form variables twice in the same email using CDOMAIL.

I have a survey form that was originally in English and I've been asked to convert it to Spanish - only they need the results email to display the survey first in Spanish- then display the same form results in English (both on the same email.)

When I try to do this it only displays one set of variables (The English.)

When I take away the duplicate code to display it only in Spanish then the spanish works but won't also display the English. :rolleyes:

Any ideas?

Thanks!

[Giskard]

Could you post some code?

[csalzman]

_________________________________________________________
HERE'S THE FIRST PART WHICH CONTAINS THE SPANISH THAT APPEARS FIRST IN THE CODE:
It's capturing the Date, Name, Organization, etc. from the top of the form
then it captures some radio buttoned questions on the form.
__________________________________________________________




<!--METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB-00C04FB1625D" NAME="CDO for Windows Library" -->

<!--METADATA TYPE="typelib" UUID="00000205-0000-0010-8000-00AA006D2EA4" NAME="ADODB Type Library" -->

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="clsCDOMAIL.asp" -->

<%

'SEND EMAIL
dim obj_CDOMAIL
set obj_CDOMAIL = new clsCDOMAIL
'------------------------------------
with obj_CDOMAIL
.FromAddress = "qualitysurvey@boyden.com"
'.ToAddress = "development@macgrp.com"
.ToAddress = "cynthia@macgrp.com"
.emailbody = CreateEmailBody()
.Subject = "Service Quality Evaluation"
end with
obj_CDOMAIL.SendEmail

'--------------------------------------------------------------------------
function CreateEmailBody()
' construct the body of the email in SPANISH
varBody = ""
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & "EVALUACIÓN DE LA CALIDAD DEL SERVICIO BOYDEN" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "FECHA: " & Request.form("date1") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "NOMBRE: " & Request.form("name1") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "ORGANIZACIÓN: " & Request.form("organization") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "NOMBRE DEL CONSULTOR DE BOYDEN: " & Request.form("consultant") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "CARGO: " & Request.form("position") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "OFICINA DE BOYDEN: " & Request.form("location") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & "PREGUNTAS Y RESPUESTAS DE LA EVALUACIÓN" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "PREGUNTA 1: El consultor se familiarizó y demostró entender a cabalidad su organización." & vbCrLf
varBody = varBody & "RESPUESTA = " & Request.form("RadioGroup1") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "PREGUNTA 2: El consultor entendió el objetivo del trabajo y del cargo." & vbCrLf
varBody = varBody & "RESPUESTA = " & Request.form("RadioGroup2") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "PREGUNTA 3: El consultor identificó y entendió sus necesidades específicas." & vbCrLf
varBody = varBody & "RESPUESTA = " & Request.form("RadioGroup3") & vbCrLf
varBody = varBody & " " & vbCrLf



______________________________________________________________
THEN COMES THE "ENGLISH" WHICH CALLS THE "SAME PARAMETERS" FROM THE FORM THAT WERE JUST DISPLAYED ABOVE IN SPANISH (EXAMPLE: DATE, NAME, ORGANIZATION, ETC.)
_______________________________________________________________


' construct the body of the email in ENGLISH
varBody = ""
varBody = varBody & " " & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & "SERVICE QUALITY EVALUATION" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "DATE: " & Request.form("date1") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "YOUR NAME: " & Request.form("name1") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "YOUR ORGANIZATION: " & Request.form("organization") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "BOYDEN CONSULTANT'S NAME: " & Request.form("consultant") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "POSITION TITLE: " & Request.form("position") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "BOYDEN OFFICE: " & Request.form("location") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & "SURVEY QUESTIONS AND ANSWERS" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "=================================================================" & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "QUESTION 1: The consultant knew and understood your organization" & vbCrLf
varBody = varBody & "ANSWER = " & Request.form("RadioGroup1") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "QUESTION 2: The consultant understood the assignment and the position" & vbCrLf
varBody = varBody & "ANSWER = " & Request.form("RadioGroup2") & vbCrLf
varBody = varBody & " " & vbCrLf
varBody = varBody & "QUESTION 3: The consultant effectively understood your unique needs" & vbCrLf
varBody = varBody & "ANSWER = " & Request.form("RadioGroup3") & vbCrLf
varBody = varBody & " " & vbCrLf



________________________________________________________________________
SO, IF I TAKE OFF THE TOP PIECE OF CODE THAT REQUESTS ALL THE FORM PARAMETERS WITH THE SPANISH PREFIX TEXT - THEN THE FORM WORKS.

OR, IF I TAKE OFF THE BOTTOM PIECE OF CODE THAT REQUESTS ALL THE SAME FORM PARAMETERS WITH THE ENGLISH PREFIXED TEXT - THEN IT WORKS.

BUT IT JUST DOESN'T LIKE DISPLAYING THE SAME PARAMETERS TWICE IN THE SAME EMAIL.

IS THIS SOMETHING THAT I CAN WORK AROUND?

SORRY FOR THE ALL CAPS TEXT - I WAS JUST TRYING TO MAKE IT EASIER TO READ FROM THE CODE DISPLAYED ABOVE. :)

THANKS FOR YOUR HELP.

CYNTHIA

[kelly23]

You've set varBody="" before creating the English version so the Spanish version is deleted.

Name each of them something different like varSpanish and varEnglish instead of varBody (the same variable name).