Thread: send excel workbook as attachment to multiple users
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default 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
Reply With QuoteReply With Quote