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