creating an e-mail from cells located in excel

[Cablek]

I would like to create a button to allow a sales person to send an e-mail to purchaser and populate the subject with fields withing the file..

so I have a sheet called Employees and in that sheet there is a table defined as "Purchasers" with names and e-mail addresses


[TABLE="width: 383"]
<tbody>[TR]
[TD]Purchasers (cell C1)[/TD]
[TD]Email (cell D1)[/TD]
[/TR]
[TR]
[TD]name1 (Cell C2)[/TD]
[TD]Name1@xyz.com (cell D2)
[/TD]
[/TR]
[TR]
[TD]Name2 (Cell C3)[/TD]
[TD]Name2@xyz.com (cell D3)[/TD]
[/TR]
[TR]
[TD]Name3 (Cell C4)[/TD]
[TD]Name3@xyz.com (cell D4)[/TD]
[/TR]
[TR]
[TD]Name4 (Cell C5)[/TD]
[TD]Name3@xyz.com (cell D5)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

when "send request to purchaser is clicked on the Sales Request sheet I'd like it to pull up the names of the purchasers in outlook to be able to chose who to send it it

Also in the subject line I would like it to put the information from cells B3 C3 D3 and F5 also from the Sales Request sheet (e.g. Please see sales request for B3, C3 "rev" D3 for Qty F3

I know how to create the button but the VBA code is a bit much

 

[ranman256]

I have a solution workbook to send you. Send me a message where to email it.
There is no Attach function here.

 

[Cablek]

You can send it to andrewr_spam@yahoo.ca

this is an email I use to receive files outside my company e-mail

thanks Ranman256