Multiple E-mail Recipients

[reece]

I have a table called [Sites] that has 2 columns: [Sites] and . There
is a combo box in my form called (Sites) that allows the user to select a
[Sites]. The [Email] column is not seen, but I need the form to e-mail the
completed form to the corresponding e-mail as to what [Sites] they selected
via a macro button at the bottom of the page.

i.e.
The table has:
Sites Email
Texas | [email protected]
Florida | [email protected]
Nevada | [email protected]
etc. etc.

The form has a combo box that lists the sites.

Depending on what they chose as the site, I need the macro e-mail button to
e-mail the form to the corresponding address.

Thanks in advance!

 

[Arvin Meyer [MVP]]

Have a look at the sample database here:

http://www.datastrat.com/Download/EmailSenate2K.zip

 

[reece]

Man....I don't know enough about VB to understand that, chief...Unless there
is another way to do it, I guess I'm outta luck.

Sorry my novice is showing.

Have a look at the sample database here:

http://www.datastrat.com/Download/EmailSenate2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I have a table called [Sites] that has 2 columns: [Sites] and .
There
is a combo box in my form called (Sites) that allows the user to select a
[Sites]. The [Email] column is not seen, but I need the form to e-mail the
completed form to the corresponding e-mail as to what [Sites] they
selected
via a macro button at the bottom of the page.

i.e.
The table has:
Sites Email
Texas | [email protected]
Florida | [email protected]
Nevada | [email protected]
etc. etc.

The form has a combo box that lists the sites.

Depending on what they chose as the site, I need the macro e-mail button
to
e-mail the form to the corresponding address.

Thanks in advance![/QUOTE]
[/QUOTE]

 

[Arvin Meyer [MVP]]

Take a deep breath. Exhale slowly ....

Now. Import everything from my database into a copy of yours.

Slowly replace things in my form and my code with the names of yours until
everything works. If you mess it up, try again on another copy. You'll
figure it out. It isn't rocket science (and the computer science has already
been done for you)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Man....I don't know enough about VB to understand that, chief...Unless
there
is another way to do it, I guess I'm outta luck.

Sorry my novice is showing.

Have a look at the sample database here:

http://www.datastrat.com/Download/EmailSenate2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I have a table called [Sites] that has 2 columns: [Sites] and .
There
is a combo box in my form called (Sites) that allows the user to select
a
[Sites]. The [Email] column is not seen, but I need the form to e-mail
the
completed form to the corresponding e-mail as to what [Sites] they
selected
via a macro button at the bottom of the page.

i.e.
The table has:
Sites Email
Texas | [email protected]
Florida | [email protected]
Nevada | [email protected]
etc. etc.

The form has a combo box that lists the sites.

Depending on what they chose as the site, I need the macro e-mail
button
to
e-mail the form to the corresponding address.

Thanks in advance![/QUOTE]
[/QUOTE][/QUOTE]

 

[reece]

Well I couldn't put it together completely, but looking through your code I
found a few bits and pieces I used to make it work.

Thanks a mill!

Take a deep breath. Exhale slowly ....

Now. Import everything from my database into a copy of yours.

Slowly replace things in my form and my code with the names of yours until
everything works. If you mess it up, try again on another copy. You'll
figure it out. It isn't rocket science (and the computer science has already
been done for you)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Man....I don't know enough about VB to understand that, chief...Unless
there
is another way to do it, I guess I'm outta luck.

Sorry my novice is showing.

Have a look at the sample database here:

http://www.datastrat.com/Download/EmailSenate2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


I have a table called [Sites] that has 2 columns: [Sites] and .
There
is a combo box in my form called (Sites) that allows the user to select
a
[Sites]. The [Email] column is not seen, but I need the form to e-mail
the
completed form to the corresponding e-mail as to what [Sites] they
selected
via a macro button at the bottom of the page.

i.e.
The table has:
Sites Email
Texas | [email protected]
Florida | [email protected]
Nevada | [email protected]
etc. etc.

The form has a combo box that lists the sites.

Depending on what they chose as the site, I need the macro e-mail
button
to
e-mail the form to the corresponding address.

Thanks in advance!
[/QUOTE][/QUOTE]
[/QUOTE]