What is the code to send an excel file with Oulook

[RFeniuk]

I have an excel spreadsheet that I want to send to multiple users in outlook. I have tried to record a macro to use the "file--send--to mail recipients" command. When I run the macro is simply opens up a new dialogue box that I have to select user names for.

What I want it to do is to automatically select the same names each time and send the file.

Can this be done?

Thanks
Ron

 

[chandlm]

Ron,

This should be what you are after

ActiveWorkbook.SendMail Array("someone@somewhere.com", "someoneelse@somewhere.com&quot


HTH



Matt

 

[KenWright]

Ron de Bruin has a great addin called SENDMAIL to do this and much more, and most of the code is freely available as well:-

http://www.rondebruin.nl/

Great little newsgroup search addin as well.

Regards
Ken..............