Im trying to figure out how to email in excel using VBA. I can get it to work but what im using is limited. I would like to email an attachment to a large amount of people, have a CC line, subject, and body. The email addresses change each time i run my program. Some are added and some are dropped so the people i email this spreadsheet to change. Is there anyway to create a string of addresses and use that string on the To: line somehow?