Modifying VB Code/Macro to put selection into body of email instead of attachment.

Please help! I am trying to work with a macro that was created before me -- and am a very beginner VB user. I am trying to use the currect code and place the selection of rows (based upon formulas) into the body of an email. It currently adds the selection onto a new worksheet. I need to modify this instead of sending in Outlook with attachment to sending in Outlook (in body of message).

Can you please look at this code and help me?

I have included 2 attachments that is the actual code.

Thank you!!!

Have a look at Ron DeBruin's page for info on sending a defined range of a sheet as the body of an email.

http://www.rondebruin.nl/mail/folder3/mail4.htm

If you still need more help it would be helpful to attach your Excel workbook and specify the sheet and range that you want to email.

Yes, I saw his forum, but still couldnt understand what to do. I've attached the workbook. The way it works is on the "Weekly Priorities" tab it takes all project information assigned to each resource and formats it and puts on this sheet tab. Then to the right of sheet there is an email table with resource names and email addresses. It then takes just the one section of each resouce (on the same sheet) and sends to just that person. For example is Caroline Wells will only receive her section. I just need to be able to modify the macro to put into body of email instead of an attachment.

Oh, please when testing this, do not send any emails to anyone - so make sure to mark "N" for No next to each name....

THANK YOU!!!!!

I've added another button "Send Email (Body)" but unfortunately I don't have Excel 2010 so I can't test it.

Try it and see if it works.

Awesome thanks!! It works )))