Hi, sorry if I appear totally lame but I know just enough VBA to be
highly dangerous. I am trying to make a small dialog that will do many
things, including email the active workbook to user's choice of email
addresses.
I have checkboxes by each name which will correspond to a specific email
address, plus one with a text box that will allow a user to supply an
email address, like this:
cbCustomer
|-tbCustomerEmail
cbSales
cbAdmin
cbMfg
cbSupport
cbMgmt
What I want to do is first check to see if all of the checkboxes are not
selected, and throw up a msgbox, then build an array based out of the
selected checkboxes and add them into this line of code:
ActiveWorkbook.SendMail Recipients:=arrayEmail, Subject:="Please
process this order immediately"
Application.Dialogs(xlDialogSendMail).Show
My questions:
1 - How can I build the arrayEmail depending on which checkboxes are
selected?
2 - Is that the best way to email the active workbook? It pops up
the dialog about "Something is trying to send email from this app - OK?"
which I would rather not have.
Best regards,
Me
Bookmarks