Sending an email from Access is done easily via the SendObject method, as in
the following example:
DoCmd.SendObject acSendNoObject, , ,
jo*****@spamthis.com, , , "Message
Subject Here", "Message Body Here"
That will open up a new email message with the above recipient. Now, if you
want to send to a group of people, you need to clarify if you want to get
the list of people directly from a table, or from a form you're looking at.
From a table, you would simply open a recordset, step through each record,
and pass the email to a string like so:
Do while not recsetAddress.Eof
strTo = strTo & "; " & recsetAddress.email
recsetAddress.MoveNext
Loop
strTo = Mid(strTo, 2)
Then, you can pass the strTo variable to the fourth argument of the
SendObject method (e.g: the "TO").
If you're using a form, well, that gets a bit more complicated, and you'll
have to step through records within the form. Let me know if you need to do
this, and I'll pull some code up and post if for you.
Hope that helps some.
JV
"acni" <nb***@artscouncil-ni.org> wrote in message
news:4b******************************@localhost.ta lkaboutdatabases.com...
I've been trawling through the internet to find out how to send emails to
selected email addresses in access but cant seem to find anything.ive a
database that im workin on with name address etc etc.there is a tick box
beside each person and im wantin to select a number of people and send
them the same message.i want outlook to open a new email.was wonderin is
this possible and if so how do you do this?
Thanks
Neil