Send to mail recipient macro

[jober13]

I am trying to record a macro in Excel that will send the current work sheet as an e-mail. I have recorded it several times and it will not work. Is this possible?

I am also trying to execute a v look up that will create a log from from a worksheet. Basicallly the worksheet is a PO template and I have recorded a macro to clear it and want to log it off of po number in a differnt sheet so I can keep a record of it. I would like to include this macro before the clear language takes place.

Thanks!

 

[VoG]

Hello and welcome to MrExcel.

For the e-mail question see http://www.rondebruin.nl/sendmail.htm

 

[jober13]

Thanks for the e-mail macro, it worked perfect!! Any thoughts on the vlookup macro?

 

[VoG]

I suggest that you start a new thread for that - it isn't mentioned in the title of this one.

You might want to post a shot of your sheet to illustrate - see http://www.excel-jeanie-html.de/html/hlp_schnell_en.php