J
jatman
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 = "(e-mail address removed)"
.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
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 = "(e-mail address removed)"
.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