Problems with Send Email Module

[Guest srusse01]

please can you look at this output in the event logger and advise what I have done wrong. It won't let me send an email.

 

120617.27 7 [send Email test] Send Email

120617.27 7 RVreplace start: [test message xxx New Recruit $RV[GetStudyId_1_1]]

120617.27 7 RVreplace end: [test message xxx New Recruit 612300]

120617.27 7 RVreplace start (strlen>100)

120617.28 7 Que email to: xxxx@mail.wch.sa.gov.au

120617.28 0 eng EmailDbQueue_Insert_Error Syntax error (missing operator) in query expression ''This is an automatic message generated when VoiceGuide has randomised a woman into the xxx Trial - 612300

 

Hospital Code = 1000

Patient UR = 11

Mother's DOB = 12/05/84

Multiple Birth = 1

BirthWeight (1 = <1250gms, 2 = >=1250gms) = 1

Strata = 1

DateRand = 20/02/2004

Time Rand = 12:05:57

StudyID = 612300

AllocGroup = Yellow

', '', 0, 'MAPI', 0, 0, '', '', '', 0, '', 0, 0, '', '', '', 0, 0, 3, 10)'.

 

 

 

Any help would be greatly appreciated.

[SupportTeam]

Which version of VG are you using?

 

Can you please post the VG script as well.

[Guest Sarah]

I am using the latest version....I think...5.1.7

 

The Script is as follows

 

[send Email test]

Type=Send Email

DispSize=69

Txt=Send email message and attachments.

strEmailAddrTo=cnrctrials@mail.wch.sa.gov.au

strEmailSubject=test message DINO New Recruit $RV[GetStudyId_1_1]

strEmailMessageText=This is an automatic message generated when VoiceGuide has randomised a woman into the DINO Trial - $RV[GetStudyId_1_1]\

\

Hospital Code = $RV[Enter Hospital Code]\

Patient UR = $RV[EnterUR]\

Mother's DOB = $RV[MDOB_DAY]/$RV[MDOB_MONTH]/$RV[MDOB_YEAR]\

Multiple Birth = $RV[MultipleBirth]\

BirthWeight (1 = <1250gms, 2 = >=1250gms) = $RV[birthWeight]\

Strata = $RV[GetStrata_1_1]\

DateRand = $RV[Date]\

Time Rand = $RV[Time]\

StudyID = $RV[GetStudyId_1_1]\

AllocGroup = $RV[GetStudyId_2_1]\

 

strEmailAttachmentFileName=

iEmailAttachmentDeleteAfterSend=0

strEmailReturnAddress=

strEmailReturnName=

strEmailCC=

strEmailBCC=

lEmailSendRetries=3

lEmailRetriesDelay=10

strEmailSendMethod_1=MAPI

strEmailSmtpServ_1=

lEmailSmtpPort_1=0

iEmailSmtpUseAuth_1=0

strEmailSmtpAuthUser_1=

strEmailSmtpAuthPassword_1=

strEmailSendMethod_2=SMTP

strEmailSmtpServ_2=

lEmailSmtpPort_2=0

iEmailSmtpUseAuth_2=0

strEmailSmtpAuthUser_2=

strEmailSmtpAuthPassword_2=

on {success} goto [Log Sent email]

on {fail} goto [Log Sent email]

 

Position=234,990

 

 

thanks for your help in anticipation

[SupportTeam]

Just tested with the module details provided and it worked fine for me (tested with 5.1.8).

 

Could you please try:

 

1. stop VG.

2. delete the EmailQue.mdb file in VoiceGuide's \data\ subdirectory

3. start VG and try running script again.

 

(If you have recently upgraded to v5.1.7 then EmailQue.mdb may be still in the old format and that may be causing your problems)

 

If you re still experiencing problems can you please try uninstalling v5.1.7 and installing v5.1.8 (current download from our WWW)

 

(you may want to backup your voicemailbox config before uninstalling v5.1.7)

[Guest Sarah]

I have now uninstalled version 5.1.7 and installed 5.1.8 as directed, and I can't even open it as I get a message "Runtime error 9 - subscript out of range and then it closes.

 

Please help me urgently as I am running out of time to get this up and running.

 

thanks

[Guest srusse01]

fixed. When I quickly entered the registration code it disappeared.