I have used the macro below to send e-mail successfully to one recipient but I am having difficultly altering it to send to mulitple addressees. I am certain I have overlooked the obvious and would appreciate someone putting me out of my misery. Thanks in advance.
- Sub Send1Sheet_ActiveWorkbook()
- 'Create a new Workbook Containing 1 Sheet _
- and sends as attachment.
- With ActiveWorkbook
- .SendMail Recipients:="[email protected]", _?????
- Subject:="Debrief " & Format(Date, "dd/mmm/yy")
- .Close SaveChanges:=False
- End With
- End Sub