email an excel sheet in the message area

Bob T · May 17th, 2002, 01:32 PM

I have a form created in Excel and I would like to send it as the message area of a new email by clicking a button. I would really appreciate your help.

Brian · May 17th, 2002, 02:23 PM

search this site for "send", "e-mail", "email" to find solutions,

See:
http://www.mrexcel.com/board/viewtop...c=7311&forum=2

Yes, you can obtain complete control of outlook from excel and presumably, excel from Outlook. In VBA Editor, Choose References and check all of the Outlook libraries.

Search the MS site & help for more info on the commands.

Nimrod · May 17th, 2002, 02:33 PM

If you want to send the spreadsheet as an attachment then:
ActiveWorkbook.SendMail Recipients:=EmailAddr

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

May 17th, 2002, 01:32 PM	#1
Bob T New Member Join Date: May 2002 Posts: 17	I have a form created in Excel and I would like to send it as the message area of a new email by clicking a button. I would really appreciate your help.

May 17th, 2002, 02:23 PM	#2
Brian Board Regular Join Date: Apr 2002 Posts: 113	search this site for "send", "e-mail", "email" to find solutions, See: http://www.mrexcel.com/board/viewtop...c=7311&forum=2 Yes, you can obtain complete control of outlook from excel and presumably, excel from Outlook. In VBA Editor, Choose References and check all of the Outlook libraries. Search the MS site & help for more info on the commands.

May 17th, 2002, 02:33 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	If you want to send the spreadsheet as an attachment then: ActiveWorkbook.SendMail Recipients:=EmailAddr