Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual basic 6.5 question using combo box and call procedure. | Excel Discussion (Misc queries) | |||
Visual Basic Question | Excel Worksheet Functions | |||
visual basic coding question | Excel Discussion (Misc queries) | |||
Visual Basic Question | Excel Discussion (Misc queries) | |||
Visual Basic Question | Excel Programming |