Problem: Export field info to email message

S

scubadiver

Hi,

I am using the following code to export field info to an email but it works
fine ONLY after I first open the DB (ignore "blah blah")

Private Sub Tracksht_Click()

Dim strToWhom As String
Dim strMsgBody As String
Dim strSubject As String

strSubject = blah blah
strToWhom = blah blah
strMsgBody = blah blah

DoCmd.SendObject , , , strToWhom, , , strSubject, strMsgBody, True

End Sub

When I try to click on the button again I get a 2957 run-time error. The
"DoCmd" line gets highlighted.

Any ideas why I can't do this repeatedly?

cheers!
 
Top