Hi, I'm trying to enable an automated email send functionality using a macro. My challenge to this point is that I want the .To property to be dynamic instead of a discrete domain address. This way I can have the macro cycle through a list of recipients and send each their corresponding data, one by one. My initial strategy was that I would be able to equate it to a variable or just set it equal to Sheets("Sheet1").Cells(1,1).Value. But to this point neither option seems to work despite the fact that those options work for .TextBody, etc. Thoughts?
Bookmarks