Need some VB guru's help...how to send multiple emails

[Legacy 55058]

I am looking to send multiple emails to different users from excel, and to email a different range in each separate email. I am not looking to send as an attachment, just within the body of the email. I have played with some code but only could get one email to go out, not multiple

 

[NateO]

Hello,

Well, hopefully you've seen this using Outlook:

http://www.mrexcel.com/board2/viewtopic.php?t=54018

Now, what you want to do is iterate, like looping through an array, e.g.,

http://www.mrexcel.com/board2/viewtopic.php?p=536376#536376

Now note, that's Lotus Note's Code, so if you're using Outlook, you don't want any of that LotusScript, etc... but you want the concept of iterating through an array, so focus on these code bits:

Let emailArr = Array("Email1@y.com", "Email2@y.com", "Email3@y.com", "Email4@y.com", _
    "Email5@y.com", "Email6@y.com", "Email7@y.com")


For i = LBound(myArr) To UBound(myArr)

    MailDoc.SendTo = emailArr(i)

Clear as mud?

 

[Legacy 55058]

That is fantastic......I am just starting to get into VBA, and learning the whole looping functionality. This is great. Thanks!!!

 

[NateO]

You are welcome.

Yep, Excel's pretty slick software, offering some really choice native functionality. And, the bonus is the ability to augment native functionality and interface other Apps via VBA, a powerful, hi-level language.

Good hunting and happy new year.