Forum Discussion
Excel Coding to send email
I have a spreadsheet that I want to send email from depending upon the date. I have it doing everything I want except it's not putting in who the email should go to. This is the code I have been us...
The line
Set Rng = .Range("AK6", .Cells(.Rows.Count, 1).End(xlUp))
sets Rng to a range in columns A, B, C, ..., AK. For example, if the last filled cell in column A is A40, Rng is the range A6:AK40
You loop through ALL cells in that range. Is that really what you intended?
Right now I'm only using one line of data to set this sheet up to send email. I will actually have about a dozen different emails in there when I get it to working right. Right now, it creates the email and puts the message in, but it is not putting in the recipient's email in the TO line.