I have an excel spreadsheet with the following command:
Application.Dialogs(xlDialogSendMail).Show "test@test.com, "CVS End of Shift " & ActiveSheet.Name
Finish:
End Sub
This works great but I have attempted to add another email recipient using a semi-colon between the two, but...