Sending Emails Via Excel

[Wamhoi]

Hi All,

I want send the a spreadsheet to several email participants. Currently I set the macro to send to just one person how can I build the macro to span the entire list.

With OutMail
.to = Range("I2").Text
.CC = Range("J2").Text
.BCC = ""
.Subject = Range("L2").Value
.Body = "Hi there"
.Attachments.Add Dest.FullName
'You can add other files also like this
'.Attachments.Add ("C:\test.txt")
.Display 'or use .Send
End With

So The end result I expect is sending an email from I2 to last email in column

 

[Asator]

http://www.rondebruin.nl/mail/folder3/message.htm

 

[Wamhoi]

This is an awesome site. Thanks so much! Do you know a way to get all the addresses on just one email.
IE: TO: John.Smith@Something.com; Jane.Smith@Something.com