Automatic E-mail sending help - Lotus Notes

[Chris Murphy]

Hi

I am using the following macro to automatically create a lotus notes message from an excel spreadsheet. is there any way this could be adapted so that the message automatically sends?

Many Thanks

_______________________________________________________________

Sub TEST2()
'
' TEST2 Macro
' Macro recorded
'

Application.Dialogs(xlDialogSendMail).Show "Email Address", "subject"
End Sub

 

[irish634]

Search CDO

Hi

I am using the following macro to automatically create a lotus notes message from an excel spreadsheet. is there any way this could be adapted so that the message automatically sends?

Many Thanks

_______________________________________________________________

Sub TEST2()
'
' TEST2 Macro
' Macro recorded
'

Application.Dialogs(xlDialogSendMail).Show "Email Address", "subject"
End Sub