Sending the mail

asramasarma · May 3rd, 2002, 05:04 AM

I need a macro which can mail the sheet as attachment. I am Not Haveing OutlookExpress. But i have SMTP server.

[ This Message was edited by: asramasarma on 2002-05-03 04:05 ]

[ This Message was edited by: asramasarma on 2002-05-03 04:26 ]

Audiojoe · May 3rd, 2002, 05:05 AM

Clicking on File>Send To>Mail Recipient does this. Could you not use this, or does it have to be a macro?

asramasarma · May 3rd, 2002, 05:08 AM

I am not having Outllok Express. But in My company We are hvaing SMTP server.

[ This Message was edited by: asramasarma on 2002-05-03 04:09 ]

Mr Nick · May 3rd, 2002, 05:27 AM

This one works for me, but I'm using Outlook.

Sub send_mail()
ActiveSheet.Copy
ActiveWorkbook.SendMail "email@address.com", "Title"
ActiveWorkbook.Close False
End Sub

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 05:04 AM	#1
asramasarma New Member Join Date: May 2002 Location: India Posts: 10	I need a macro which can mail the sheet as attachment. I am Not Haveing OutlookExpress. But i have SMTP server. [ This Message was edited by: asramasarma on 2002-05-03 04:05 ] [ This Message was edited by: asramasarma on 2002-05-03 04:26 ]

May 3rd, 2002, 05:05 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Clicking on File>Send To>Mail Recipient does this. Could you not use this, or does it have to be a macro?

May 3rd, 2002, 05:08 AM	#3
asramasarma New Member Join Date: May 2002 Location: India Posts: 10	I am not having Outllok Express. But in My company We are hvaing SMTP server. [ This Message was edited by: asramasarma on 2002-05-03 04:09 ]

May 3rd, 2002, 05:27 AM	#4
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	This one works for me, but I'm using Outlook. Sub send_mail() ActiveSheet.Copy ActiveWorkbook.SendMail "email@address.com", "Title" ActiveWorkbook.Close False End Sub