Send emails from Excel

[Shamsuddeen]

I would like to have a macro which runs outlook express and attach the active worksheet to it and sends email to the address kept in another worksheet.

Regards,

Shamsuddeen

 

[viper]

Here is the code I use to e-mail the active worksheet. What it does is make a copy of the active sheet into another workbook then sends that sheet only. But, it uses Outlook not express, I've found the code to use Express but I have yet to add the code.


Sub SendIt()
Sheet1.Copy
ActiveWorkbook.SaveAs Filename:="file name you wish to save.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=True, CreateBackup:=False
Application.Dialogs(xlDialogSendMail).Show _
arg1:="email address", _
arg2:="subject"

End Sub

keep you posted on the express thing.