Stephen Bond
stephen at bondsoftware.co.nz
Fri Feb 27 22:13:39 CST 2004
I am sending one e-mail to each person on file. Each e-mail has that person's individual details. Here is the code snippet ... ======= If Not rs.BOF And Not rs.EOF Then rs.MoveFirst Do Until rs.EOF GoSub BuildBodyOfEmail ' build field 'eMailBody' MsgBox "email for " & rs!pId & " " & rs!pSurname DoCmd.SendObject acSendNoObject, , , _ "mytest at mydomain.co.nz", _ , , "Subject Test", _ eMailBody, True rs.MoveNext DoEvents Loop End If ======== The problem is the first record in the recordset pops up as a new mail message OK, but subsequent records don't. The debugging MsgBox comes up for each record so I know the loop is getting the right records. Changing the SendObject's 'editmessage' flag from True to False doesn't make any difference. Eventually I want to change the SendObject's 'editmessage' flag from True to False so the e-mails go straight out without visual verification. The False is for testing purposes meantime. Weird. Any thoughts ..... Stephen Bond