View Single Post
  #2 (permalink)  
Old November 4th, 2009, 06:03 PM
mat41 mat41 is offline
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

I suspect this line:

SendEmail CustomersRS("CustomerEmail")

Should be commented out in your code. It does nothing as far as I can see. In any case the above line is useless. If SendMail was a variable and it said:

SendEmail = CustomersRS("CustomerEmail")

That would make sense. Looking into your code SendMail is a function and is used like so:

function SendEmail(c)

And then further down your code the value in the parameter 'c' is used for the to address:

objMail.To = c

Therefore this makes me think you need to change:

SendEmail CustomersRS("CustomerEmail")

To

SendEmail(CustomersRS("CustomerEmail"))

What this does is pass the email address in CustomerRS("CustomerEmail") into the function
__________________
Wind is your friend
Matt
Reply With Quote
The Following User Says Thank You to mat41 For This Useful Post:
futurehype (November 9th, 2009)