Creating e-mails automatically

[Gavin]

Hi, this may sound like a silly question, but i'm
relatively new to access and would be very gratefull if
you could solve a problem that has stumbled me.

I want to be able to create an email using addresses
obtained from an email field either from a table or
query. I want the addresses to all be in the 'TO' line of
the email, but cant seem to find a way to merge them
together and place them in the email, ie with the ;
divider etc. I figured there must be a simple way to send
one email to multiple people using access, i know how to
create a one address email, but this has be stumped.

I would rather not use word ect if anyone thinks this
would be a solution, as i would like the emails to be
created automatically.

Thanking you in anticipation.

G Peacock
..

 

[Jim/Chris]

It is really quite easy.
I use a form to create my recipient, subject, text, and
report name. I send my reports as snapshots.
The report name is from a combo box
The subject and text come from an unbound text box
The recipient comes from and unbound text box base on
selections in a combo box
Everytime I click on the recipient combo box that value is
appended to whatever value is in the recipient textbox
along with the mail separator.
When I am finished checking the names, filling in the
subject and text and selecting the report I use a command
button to send the email using the docmd.sendobject

Hope that helps

Jim