send excel workbook as attachment to multiple users
 

How can I create an VBA macro so that I can email a sheet within a workbook
to multiple users

send excel workbook as attachment to multiple users
 

copy the sheet, then use sendmail. close the copy without saving

Activesheet.copy
Activeworkbook.SendMail Recipients:=Array("a@B","c@D"), Subject:="Open Me"
Activeworkbook.close Savechanges:=False

--
Regards,
Tom Ogilvy


"guz" wrote:

How can I create an VBA macro so that I can email a sheet within a workbook
to multiple users