Search results

: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 ";".

Thanks. I checked the Immediate Window under the View menu and all 3 email addy's appear fine with colon's however they also start with a colon too. ;email@email.com;email@email.com;email@email.com

Tried that one to and same error message? Strange.

Appreciate all your help thus far! Now all I get is: Uknown Message Recipient(s); the message was not sent. I set up a query to return 3 results of email addresses, all of which are correct, and ran this in the VB code for the command button on the form that launches the query and that's...

If I change the code up a little and run it on a query that has the results in one column, using the code below generates an email but does not loop through to add the subsuequent email addys. What I'm getting is the email with the first email address and not the others. Dim MyDb As...

Seems like this question has been beat to death but I've yet to find anything that works for me. Access 2003 I've got a form with a drop down that runs a query with many email addresses in a field called "EmailAddress" by default. This field is in column 4, after a few other fields. I'd...