email question

[Jeff]

I am developing an Access database application. I have a one table with three
fields: name, team #, and email address. I have another table where a person
enters a list of things to be requested from a team (lets say the fields
are request #, item, and team #). I am attempting to write a little VB code
within this Access application that will automatically send an email to everyone
that is a member of a team that request was entered for. The main problem
I am having is the VB code to send the email. Any help is greatly appreciated!
Thanks, Jeff

[Douglas J. Steele]

Check out the Access E-Mail FAQ that Tony Toews has at
http://www.granite.ab.ca/access/email.htm

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/


"Jeff" <jbarnes@eworlddevelopers.com> wrote in message
news:3afb5283$1@news.devx.com...
>
> I am developing an Access database application. I have a one table with
three
> fields: name, team #, and email address. I have another table where a
person
> enters a list of things to be requested from a team (lets say the fields
> are request #, item, and team #). I am attempting to write a little VB
code
> within this Access application that will automatically send an email to
everyone
> that is a member of a team that request was entered for. The main problem
> I am having is the VB code to send the email. Any help is greatly
appreciated!
> Thanks, Jeff

[Jeff]

Thanks for the help got it to work now!

"Douglas J. Steele" <djsteele@canada.com> wrote:
>Check out the Access E-Mail FAQ that Tony Toews has at
>http://www.granite.ab.ca/access/email.htm
>
>--
>
>Doug Steele, Microsoft Access MVP
>Beer, Wine and Database Programming. What could be better?
>Visit "Doug Steele's Beer and Programming Emporium"
>http://I.Am/DougSteele/
>
>
>"Jeff" <jbarnes@eworlddevelopers.com> wrote in message
>news:3afb5283$1@news.devx.com...
>>
>> I am developing an Access database application. I have a one table with
>three
>> fields: name, team #, and email address. I have another table where a
>person
>> enters a list of things to be requested from a team (lets say the fields
>> are request #, item, and team #). I am attempting to write a little VB
>code
>> within this Access application that will automatically send an email to
>everyone
>> that is a member of a team that request was entered for. The main problem
>> I am having is the VB code to send the email. Any help is greatly
>appreciated!
>> Thanks, Jeff
>
>