Reading Email Addresses from Cells into Sendmail
I'm trying to use the Sendmail method to email a spreadsheet to the list of email addresses on the spreadsheet. I know that Sendmail takes a Variant argument. How do I assign a value to my Variant array so that the Sendmail method actually works?
I think the problem is something to do with the quotation marks the Sendmail argument would normally expect. I dont want to type quote marks around each email address in the list in the cells in the spreadsheet.
Here is what I am trying to run:
Public Sub mailing()
Dim list As Variant
list = Array("a12:a20")
ActiveWorkbook.SendMail Recipients:=list
End Sub
The cells referenced contain the email addresses ie:
[email protected]
[email protected]
Yes, I am new to VBA