I have a macro that works perfectly fine where it emails the current workbook to multiple recipients. The thing I need help with is that at the moment the email list is hard coded and I would like to be able to pick the address from a cell or group of cell from the worksheet. so the email list can be changed without anyone needing the understanding of VBA and macros. The subject line works fine, I have fixed text followed by data in two different cells but so far I have failed to get the names to work this way. Below is the code. I would appreciate help
Sub Email()
Dim RecipVal As Variant
RecipVal = Array("[email protected]", "[email protected]")
ThisWorkbook.SendMail Recipients:=RecipVal, _
Subject:="Email Test -" & Range("A1") & Range("b1")
End Sub
Bookmarks