View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Create a Command Button to Send E-Mails to selected recipients

Hi MeMe

You find all the code you need on this page
(click also on the Tip page link on each example page0
http://www.rondebruin.nl/sendmail.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"MeMe" wrote in message ...
I have an excel file that I send weekly to some Managers. Currently, I copy
and paste a list of e-mail addresses in a new Outlook message and then send
the file. I wanted to create a Command Button, but I can't create the VBA
code to send the excel file via Outlook. Can I get some help please?

thanks, meme