Linking Excel to Microsoft Outlook

[Rjwsoccer7]

I want to write a macro that opens microsoft outlook, creates a new message, copies and the pastes a selection of cells into the message and sends it to a set group. I've got the macro down to open microsoft outlook, but I how can I then manipulate outlook to do what I want? Is this even possible? Thx.

 

[Juan Pablo González]

Check this out:

http://www.mrexcel.com/board/viewtopic.php?topic=8251&forum=2

 

[Rjwsoccer7]

great, thanks. This will work perfectly.