Hi. I have VBA code to send emails. I am having a problem with a long list of emails and I would like to line space between them. I have tried the example below which does not work. I have also tried referring to range.("A1:A50") which does not work. Any help is appreciated. Thanks.
.To = ThisWorkbook.Sheets("Sheet1").Range("A1:A50")