Karen:
Probably the easiest approach, in my opinion, would be to use the SendObject
function. You can create a recordset from the table and loop through each
record in the recordset, specifying the email address from the recordset as
one parameter for the SendObject method and the other fields from the
recordset can be used to construct the message parameter of the SendObject
method. For example:
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim sMessage As String
Set db = CurrentDb
Set rs = db.OpenRecordset("MyTableName")
Do Until rs.EOF
sMessage = "Start Date: " & rs("StartDateFieldName") & vbCrLf & _
"Name: " & rs("NameFieldName") & vbCrLf & _
"Age: " & rs("AgeFieldName")
DoCmd.SendObject acSendNoObject, , , rs("EmailFieldName"), , ,
"Database Variation Email", sMessage, False
Loop
Set db = Nothing
Set rs = Nothing
You can also use Outlook automation to send the email. The following KB
article give more information on doing this. You would use this code inside
the recordset loop.
http://support.microsoft.com/default.aspx?scid=kb;en-us;209948
--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com
This response is supplied "as is" without any representations or warranties.
"release of child to receive medical care"
message I am using Access 2003. I have a table with about 130 records. One field
in this table is their email address. I want to send to each person an
email
with their personal information so they can reply and verify that the
information I have is correct. How do I do this? I am a beginner at Access
so I need any help with programming. Thanks.
Karen
