AnotherHiggins
Technical User
Hello all,
This is my first time posting here. I have searched the site and can’t find quite what I’m looking for, so here it goes:
I’m using Excel 2000, Visual Basic 6.0 and GroupWise 6.5. In automating a few reports that I send out daily, I’ve got everything down to a single button-click (buttons on a custom macro toolbar). But I’m not happy with the way I’m sending emails. Currently I’m using .sendmail to generate the emails as follows:
While this is functional to send emails to multiple recipients, I have a couple of reports that go out to all our DMs, RMs, Directors and various other members of management (about 30 people altogether). I don’t want to have to manually change the list of recipients when someone comes or goes. I’ve defined the variables in a public function so I can call them from multiple macros, but I still have to keep up with multiple mailing lists in VB. This is tedious and seems silly considering that someone already keeps mailing lists up to date in a shared Address Book within GroupWise.
The problem I’m running into is whenever I specify a custom group as an address, I get an email from me with no recipients sitting in my inbox!?!
Any help would be appreciated. And just a warning, I’m still just learning VB, so I may have follow-up questions.
Thanks in advance,
John
This is my first time posting here. I have searched the site and can’t find quite what I’m looking for, so here it goes:
I’m using Excel 2000, Visual Basic 6.0 and GroupWise 6.5. In automating a few reports that I send out daily, I’ve got everything down to a single button-click (buttons on a custom macro toolbar). But I’m not happy with the way I’m sending emails. Currently I’m using .sendmail to generate the emails as follows:
Code:
Recipients = Array("recipient1@domain.com", " recipient2@somewhere.com", "recipient3@elsewhere.com")
ActiveWorkbook.SendMail Recipients, "CVS AUR's"While this is functional to send emails to multiple recipients, I have a couple of reports that go out to all our DMs, RMs, Directors and various other members of management (about 30 people altogether). I don’t want to have to manually change the list of recipients when someone comes or goes. I’ve defined the variables in a public function so I can call them from multiple macros, but I still have to keep up with multiple mailing lists in VB. This is tedious and seems silly considering that someone already keeps mailing lists up to date in a shared Address Book within GroupWise.
The problem I’m running into is whenever I specify a custom group as an address, I get an email from me with no recipients sitting in my inbox!?!
Any help would be appreciated. And just a warning, I’m still just learning VB, so I may have follow-up questions.
Thanks in advance,
John
