macro that sends email

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi, Vikas,

Originally Posted by TO

I was trying to attach my file here but its not letting me to.

I wonder if the user would be able to do so after your request.

@rhndrixxxx:
You could have attached youir macro or advised which mail program you want to use. Maybe have a look at Mail Range/Selection in the body of the mail and have a look at the Function RangeToHTML.

Ciao,
Holger

Hi Experts,

Thanks for the quick response. I have attached two files. one is the file that I'm using and the other one is the snapshot of what it should look like.
There should be a "clickable" button to run that macro.

If possible please allow me to place some comments or message before we place the screenshot in outlook (ex. "Hi, please see attendance data....").

I really appreciate all the help.

Sorry, for the belated response.
Here are the codes you may be interested in :-

Excel VBA - E-Mailing a Selection, Range or whole worksheet (as Email Body)