Sending Email to list of addresses from worksheet

Hi All,

I want to send an email to a list of email addresses located on a worksheet. I had hard-coded the addresses previously, but I know have to keep these in a worksheet instead. I have setup the following code that appears to be almost ready, but I am missing something here. I get an error at this line:

.To = ws.Range("A" & i).Value , error is "Object doesn't support this property or method"

Any thoughts?

Please Login or Register  to view this content.

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks