Email to different addresses

[benkayuk]

Hi, I am designing a site for a company with dealers in different countries.
For each product I have a 'request info' form with name, address, email address
and country fields. At present the form simly sends the email out to my
address, but I need it to send to the relevant country dealer. This should be
automatically chosen by the option the user selects in the 'country' drop-down
list. How do I go about doing this? Thanks, Ben Kay

[vkunirs]

Hi

for sending the mail from where you are getting the maild id's.

i think for this you are using some query like "select * from table".
then if you want to send to the countries which is selected by the user then
give where condition like this
where country='#form.country#'

:cool;

[benkayuk]

Not sure I fully follow......is this even something that has to be done with Coldfusion? Or can it be done without server input?

Ben

[Tom CF]

This will be done using Coldfusion.

U will do something like this:

fetch the email id using query

select * from tblName where country = #form.txtCountry#

Now this queryname.emailaddress in the "to" of cfmail like

<cfmail to="qryname.Email" from="admin@yourcompany.com" subject="jksdf">
body of the email
</cfmail>