Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to send email to person in workbook list of users | Excel Programming | |||
User form and send mail | Excel Programming | |||
Form to send by Email | Excel Discussion (Misc queries) | |||
Using VBA to send email based on form response | Excel Programming | |||
cmd button, send form via email | Excel Programming |