e-mails

[angie]

i have a table with: name, e-mail, group

i have a form with the following fields: subject, message text, combos that
filter my table (the result is a query with the addresses i want)
i want to add the following fields: combo that selects file(s) to be sent
from my computer (using the browse option like in ms outlook) and button that
sends the e-mail to each record separately.
could you guide me through the steps to achieve that?

 

[Pendragon]

If you do a search in this newsgroup on "email" you will find an abundance of
code, references and links to other sites for sending out email via access &
vba. Most of it you can use with very little modification - I've found a
great deal to utilize to that effect.

HTH

Ross

 

[Piet Linden]

i have a table with: name, e-mail, group

i have a form with the following fields: subject, message text, combos that
filter my table (the result is a query with the addresses i want)
i want to add the following fields: combo that selects file(s) to be sent
from my computer (using the browse option like in ms outlook) and button that
sends the e-mail to each record separately.
could you guide me through the steps to achieve that?

for the file, use the OpenSaveFile API on Access Web.

for the messaging, check out Tony's site...
http://www.granite.ab.ca/access/email.htm

 

[cm]

i have a table with: name, e-mail, group

i have a form with the following fields: subject, message text, combos
that
filter my table (the result is a query with the addresses i want)
i want to add the following fields: combo that selects file(s) to be sent
from my computer (using the browse option like in ms outlook) and button
that
sends the e-mail to each record separately.
could you guide me through the steps to achieve that?