Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
emailing everyone on the list
I want to email everyone on the list, rather than having to click on them one
by one with the following command button. Private Sub cmdAdd_Click() Dim i As Integer For i = 0 To lstEmployees.ListCount - 1 If lstEmployees.Selected(i) = True Then lstAttendees.AddItem _ lstEmployees.List(i) lstEmployees.Selected(i) = False End If Next i cmdRemoveAll.Enabled = True End Sub Any ideas. Kindest regards PaddyMac |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
emailing everyone on the list
Just remove the check on whether an employee item is selected or not.
Private Sub cmdAddAll_Click() Dim i As Integer For i = 0 To lstEmployees.ListCount - 1 lstAttendees.AddItem lstEmployees.List(i) Next i cmdRemoveAll.Enabled = True End Sub Tim "PaddyMac" wrote in message ... I want to email everyone on the list, rather than having to click on them one by one with the following command button. Private Sub cmdAdd_Click() Dim i As Integer For i = 0 To lstEmployees.ListCount - 1 If lstEmployees.Selected(i) = True Then lstAttendees.AddItem _ lstEmployees.List(i) lstEmployees.Selected(i) = False End If Next i cmdRemoveAll.Enabled = True End Sub Any ideas. Kindest regards PaddyMac |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
emailing everyone on the list
On Oct 12, 2:42*pm, "Tim Williams" wrote:
*Just remove the check on whether an employee item is selected or not. Private Sub cmdAddAll_Click() * * Dim i As Integer * * For i = 0 To lstEmployees.ListCount - 1 * * * * lstAttendees.AddItem lstEmployees.List(i) * * Next i * * cmdRemoveAll.Enabled = True *End Sub Tim "PaddyMac" wrote in message ... I want to email everyone on the list, rather than having to click on them one by one with the following command button. Private Sub cmdAdd_Click() * *Dim i As Integer * *For i = 0 To lstEmployees.ListCount - 1 * * * *If lstEmployees.Selected(i) = True Then * * * * * *lstAttendees.AddItem _ * * * * * * * *lstEmployees.List(i) * * * * * *lstEmployees.Selected(i) = False * * * *End If * *Next i * *cmdRemoveAll.Enabled = True End Sub Any ideas. Kindest regards PaddyMac- Hide quoted text - - Show quoted text - Tim If works! Many thanks. Kindest regards PaddyMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating emailing list from column of addresses | Excel Discussion (Misc queries) | |||
Emailing | Excel Discussion (Misc queries) | |||
Emailing A List of People using VBA | Excel Programming | |||
setting up a mailing list for bulk emailing with handimail | Excel Discussion (Misc queries) | |||
emailing recipients from a list in Excel | Excel Programming |