Hi
I know this has to do with the SELECT () CASE statements in ASP. But I'm not sure how to make this work properly.
Brief: I have a form that when submitted goes to different recipients depending on a selection they have previously made from a drop-down list.

Something like:
<%
SELECT Case varDept
CASE "Finance Dept."
      ObjMail.to: [email protected]

CASE "Marketing Dept."
      ObjMail.to: [email protected]

CASE "Another Dept."
      ObjMail.to: [email protected]

End SELECT
%>

Id it as simple as I've described? If so I'm must be missing something because as it is, it isn't working.

Thanks always for all your help,
nancy

Plase check if u get the valus in varDept variable.

following is the syntax of sending mail:

<%
    Set MyCDONTSMail = CreateObject("CDONTS.NewMail")
    MyCDONTSMail.From= "[email protected]"
    MyCDONTSMail.To= "[email protected]"
    MyCDONTSMail.Subject="This is a Test"
    MyBody = "Thank you for ordering that stuff" & vbCrLf
    MyBody = MyBody & "We appreciate your business" & vbCrLf
    MyBody = MyBody & "Your stuff will arrive within 7 business days"
    MyCDONTSMail.Body= MyBody
    MyCDONTSMail.Send
    set MyCDONTSMail=nothing
%>

Your select statement will be:

SELECT Case varDept
CASE "Finance Dept."
      MyCDONTSMail.To= "[email protected]"
CASE "Marketing Dept."
      MyCDONTSMail.To= "[email protected]"
CASE "Another Dept."
      MyCDONTSMail.To= "[email protected]"
End SELECT


Om Prakash

Thank you for your feedback. However, it doesn't work. In fact it doesn't recognize the get.asp (page with the email instructions).

Here's the section of my form plus the asp code that gets the information from the form:

HTML FORM section:

************************************************** **

<select name="t1">

          <option value="information type A" selected>type A</option>
          <option value="information type B">type B</option>
          <option value="information type C">type C</option>
          <option value="information type D">type D</option>
          <option value="information type E">type E</option>
          <option value="Other">Other</option>
        </select>

************************************************** **


Here's the code in get.asp:

************************************************** ***

SELECT Case t1
CASE "information type A"
      ObjMail.To = "[email protected]"
CASE "information type B"
      ObjMail.To = "[email protected]"
CASE "information type C"
      ObjMail.To = "[email protected]"
CASE "information type D"
      ObjMail.To = "[email protected]"
CASE "information type E"
      ObjMail.To = "[email protected]"
End SELECT

************************************************** **


When completing the form (with a valid ObjMail.From value), and submitting it, get.asp cannot be displayed: HTTP 500 - Internal server error

What am I missing??

Thanks
nancy

************************************************** ***

Modify
SELECT Case t1
as
SELECT Case request.form("t1")


Om Prakash

It still isn't working. Same error message ???

I think you should turn off "Friendly HTTP Error Messages" as per the instructions in this FAQ: http://Imar.Spaanjaars.Com/QuickDocId.aspx?QUICKDOC=264

Then post the actual error message to this list....

Cheers,

Imar

Thank you it is working.

Would you like to share the solution? That may help someone else in the future when they run into a thread like this one.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Actually the code suggested was the solution. What was preventing it from working properly had to do with syntax on my part.

The solution is actually in the thread that reads:

Select CASE request.form("t1")

instead of what I had initially coded which was:

Select CASE t1

Hope this helps,
nancy