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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using VBA in Excel to Email
- Thread starter Cbluum7
- Start date
