Macro, Send to Multiple email, embedded file, title from cells, help

Hi, I looked over this forum and I have tried using some of the help given to others to make macros to send and doc but I just can get it to work right, here is what I am trying to do.

------

title the email with name from A1 date from B2 and name from D2

I have 3 spots for emails D2, G2, D3 I want to be able to type emails into those cells and the macro send it to them via Outlook

Last is to insert the excel file into the body of the email not an attachment so when I open it I don't have to open a file to see my data.


---

This is my first time using macros, and I want to learn to how to get this working. because there is a lot I want to do.

Thank you for the help

http://dl.dropbox.com/u/36047266/FTS%20Recap%20xxxxxx%20revison%20macro.xlsm

Here is what im working on.

the above I believe would work, only thing I would need is an easier way of putting emails in, so I dont have to change the macro each time.

sorry for the late answer and thanks very much for the help. OK, I messed with it. I am a little lost. Do I use the first posted or the second ones?

thank you john, 100% perfect! 100 thank you's. My only question is all I see is this code in the VB editor


Sub Button1_Click()
EmailRangeInHTML " ", "Sending Range in HTML test", Worksheets("Sheet1").Range("B6:k42")
End Sub

Where is the code you posted located? I am trying to learn this for future uses and I want to get all the info I can.

thanks again