Recent content by Scott

:rolleyes:

Sounds good! Next time I'm in Reno I'll send a pm your way. :D

Paul, I was able to trap the error message, looks great! :D

I'll try and set it up to trap it and see what happens.

All I get when I close the email is "The SendObject Action was cancelled." message. Is this the 2501 error you are referring too?

If the SELECT/CASE statement is any bit similar to a SWITCH/CASE statement in JavaScript I can probably figure that one out after some thorough research. :D

Fantastic! Paul you are the man! I must have deleted this when I replaced the code. doh Set MyDb = CurrentDb()

I'm just going to scrap the email thing, neither the reference code in the link works on this nor can I get the code you supplied to do anything. I appreciate all your help with it.

Here's an example: The "Interests" form listbox selection runs a macro which opens a query based on the selection.

I might just go with a seperate drop down asking the user if they want to email the list, then create a query with just the email results, no show, and run it that way. That might actually work out since they would then have the choice of picking whether they want to email or simply view the...

I can email it to you later.

The other option I have is using a seperate drop down to launch a query with only the email addy results, then run the vb code on that to create the email. I'm guessing I could "not show" the results of the query and simply click and email.

So I added this to the VB code behind the command button on the form that launches the query. Changed the one line to: sToName = sToName & rsEmail!EmailAddress & ";" Now I get an error "Too few parameters. Expected 1."

winner winner chicken dinner Now, what I need to do is make this code work on my "real" query where the email addy field is in the 4th column (eg after name, addy, blah blah). I know I know PIA. Is there an eays way to change the field(x) to pull from that column?

I've got a simple test query with 3 results of email addy's in the column and none are blank. Certainly, this is where the Unknown recipient is coming from though, it's expecting an email addy prior to the first ";".