Macro to create new MS Office email

I need a macro that will create a new email and will copy cell contents into the email subject line and body:

Email Subject: 'Content of cellA1' 'Content of cell B1' subject text

Email body: 'Content of cellA1' email body text 'Content of cellB1' text

Please Login or Register  to view this content.

Hi Whizbang,

Nice work - If I want to send the email with the excel file as an attachment, what does I need to add to the code then?

I´m not an expert in vba coding, so sorry if the answer is to obvious

Ok I was a bit to quick - pretty obvious I just have to add
.Attachments.Add ActiveWorkbook.FullName

Bu the questions just keeps comming

Is it possible in excel to make a makro that execute every day at 8 pm?

I am sure there is, but I'd have to look around and see what other people have done. The problem with having a macro automatically run at a certain time is that a) The workbook would have to remain open until 8pm, and b) there would have to be some sort of OnTime loop that checks the time every second until it is 8pm.

Probably the easier way would be to create a workbook with some code in the Open event that then processes whatever you need processed. Then set up a task in the Windows Task Scheduler to open up the file at 8pm.

Here is a simple description of how to set up code in the Workbook Open event:
http://www.ozgrid.com/VBA/auto-run-macros.htm

Here is a much more detailed explaination of Events in general:
http://www.cpearson.com/excel/Events.aspx