Forum Discussion
Sending attachment to email list
Hi, I am trying to send an email to a list of address from a sheet. I had this working with just placing the email address directing in the .TO = "john1@email.com" ; "john2@email.com", but when...
It would take a while to look at this in detail... Please try to use this line instead
.To = ws.Range("A" & lRow ).Value
.To = ws.Range("A" & lRow ).Value