Macro to send e-mail through outlook from excel

Hello!

I have a list of tasks (one task per row) that are assigned to different employees and I would like to be able to send an e-mail directly from the spreadsheet to the assigned person. I would like to be able to add some standard text at the beginning of the e-mail, followed by a table that contains row 1 (headings for columns A through M) and the specific row assigned to that person (columns A through M). The e-mail address of the assigned person is in column N. Is this possible to do through Outlook?

Thanks!

Very helpful thank you! I have used the following code, and would like to make a few changes but am having trouble. I want to send the e-mail to the address which is in the last cell of the selection. Also, I would like the first row (A1:N1) be included in every e-mail without having to highlight it. Is this possible?

Please Login or Register  to view this content.