I setup a useform for users to input different data which will ultimately be emailed to a pre-defined email address.
While I know how to organize the data and send the e mail, I got 2 issues I am trying to resolve.
I have a 11 checkboxes in a group, namely cb1 to cb11 with different caption.
I was wandering if anyone can teach me how I can generate a list of the ticked checkboxes caption.
i.e. If cb1 and cb5 is ticked, then the list will be the caption of only cb1 and cb5.
From the userform, I have 10 fields that I wish to be taken out, put into an excel with pre-defined headers and a pre-written macro. And send this excel as an attachment to pre-defined email.
(can this be done without using a temp file?)
Thank you for your help in advance.