CDOSYS With Variable Not Working

[Jess]

Hi,
I'm sending an email with CDOSYS. In myMail.To = emailSubmitter <-When I
use a variable here it doesn't send. When I use a specific address like
an*****@anywhere.com it works.

Here's how I set up emailSubmitter
emailSubmitter = rs("emailAddr")

Any ideas?

[Patrice]

My first though would be to see what contains rs("emailAddr")

--

"Jess" <Je**@discussions.microsoft.com> a écrit dans le message de
news:0F**********************************@microsof t.com...

Hi,
I'm sending an email with CDOSYS. In myMail.To = emailSubmitter <-When I
use a variable here it doesn't send. When I use a specific address like
an*****@anywhere.com it works.

Here's how I set up emailSubmitter
emailSubmitter = rs("emailAddr")

Any ideas?

[Kyle Peterson]

for troubleshooting sake response write the variable and make sure your get
the email address you expect

"Jess" <Je**@discussions.microsoft.com> wrote in message
news:0F**********************************@microsof t.com...

Hi,
I'm sending an email with CDOSYS. In myMail.To = emailSubmitter <-When I
use a variable here it doesn't send. When I use a specific address like
an*****@anywhere.com it works.

Here's how I set up emailSubmitter
emailSubmitter = rs("emailAddr")

Any ideas?

[Jess]

I've done the response.write and an email address comes out.

"Jess" wrote:

Hi,
I'm sending an email with CDOSYS. In myMail.To = emailSubmitter <-When I
use a variable here it doesn't send. When I use a specific address like
an*****@anywhere.com it works.

Here's how I set up emailSubmitter
emailSubmitter = rs("emailAddr")

Any ideas?