Hi!

I created a table to for the shipping department, everyday we scan the packages we send.

I would like to send a e-mail and tracking number to my clients from a template(data access page) if possible.

I found this code on this forum:
Dim rsEmail As DAO.Recordset
Dim strEmail As String
Set rsEmail = CurrentDb.OpenRecordset("YourQuery")

Do While Not rsEmail.EOF
strEmail = rsEmail.Fields("EmailAddress").Value
DoCmd.SendObject , , , strEmail, , , "Subject", "Message Text"

rsEmail.MoveNext

Loop
Set rsEmail = Nothing
Can I use something similar.

Thanks
Frank

[This message has been edited by fludan-frank (edited 01-30-2002).]