Send Email(s) by selecting users from user form
 

good day,

i have created a user form which has 11 individuals, and three groups -
using the checkbox for selections (name1, name2, name3, etc...) - the name is
displayed, not the email.

is it possible to create an email list based on the checkboxes to send an
email to the selected individuals?

i want to call the userform from within the Sub
Mail_ActiveSheet_PDF_Outlook() macro if a condition on the worksheet is met -
i can do this part;

i know that the response needs to be set at the begining of the macro as a
string so i know i need to add "Dim selection As String" to the other Dim
variables

i need to kick start the process on how to capture the selection(s) from the
userform to the variable to mail out. i want to store the email addresses
within the userform and those are used based on user selection.

i also have one more question, later in the macro where the email is
actually created i have the following:
With OutMail
.to = "
.CC = strto

i want the selection varialbe to be with the .cc strto varialbe that is
already there - basically two variables for the cc line. is it as simple as
..cc = strto; selection??

thank you,

jat

Send Email(s) by selecting users from user form
 

i should have said, there is an ok button, and with the ok button is pressed
that is when the emails are captured.

thank you,

jat


"jatman" wrote:

good day,

i have created a user form which has 11 individuals, and three groups -
using the checkbox for selections (name1, name2, name3, etc...) - the name is
displayed, not the email.

is it possible to create an email list based on the checkboxes to send an
email to the selected individuals?

i want to call the userform from within the Sub
Mail_ActiveSheet_PDF_Outlook() macro if a condition on the worksheet is met -
i can do this part;

i know that the response needs to be set at the begining of the macro as a
string so i know i need to add "Dim selection As String" to the other Dim
variables

i need to kick start the process on how to capture the selection(s) from the
userform to the variable to mail out. i want to store the email addresses
within the userform and those are used based on user selection.

i also have one more question, later in the macro where the email is
actually created i have the following:
With OutMail
.to = "
.CC = strto

i want the selection varialbe to be with the .cc strto varialbe that is
already there - basically two variables for the cc line. is it as simple as
.cc = strto; selection??

thank you,

jat