Visual Basic Mail Question
 

I have created a mail macro to automaticly send an excel
spreadsheet to a set email address. The problem I have,
is that the reciepiant recieves two email's instead of
one. I have only the one address listed. Here is a copy
of the code.

Private Sub Image1_Click()
ActiveWorkbook.SendMail ", "Subject was
here"
End Sub

Can anyone shed anylight on my problem?

Thanks

Visual Basic Mail Question
 

Your click event is probably firing twice. Put in a msgbox or something to
check. You might have some type of recursive call to it.

--
Regards,
Tom Ogilvy


"Rex Gray" wrote in message
...
I have created a mail macro to automaticly send an excel
spreadsheet to a set email address. The problem I have,
is that the reciepiant recieves two email's instead of
one. I have only the one address listed. Here is a copy
of the code.

Private Sub Image1_Click()
ActiveWorkbook.SendMail ", "Subject was
here"
End Sub

Can anyone shed anylight on my problem?

Thanks