eladkroy
Posts: 4
|
| Posted: 08/27/2007, 10:21 AM |
|
when data is entered on my form, I want that data to be emailed to one of two addresses according to the zip code. For example, if the form has the zip code 76687, I want it emailed tofred@abc.com. If the form is submitted with zip code 76600, I want it emailed tosusan@abc.com. How can I do this?
I have created a DB (MSaccess) with all of the appropriate zip codes (field1) and corresponding email addresses (field2). can I use this to filter the data.....if zip=field1, insert field2? I am very much a beginner at this.
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 08/27/2007, 8:30 PM |
|
eladkroy
You appear to be heading in the right direction. all you need to do is to have a query pull the email address based on the zip code and plug it in your email statement. i.e. $email = CCDLookUp("emailaddress","ziptable","zip=".$form->zipcode->GetValue(),dbase)
|
|
|
|
|
