I used the same macro name for all three just to see what shows up....
So where do I test it? As under the VBA area and I hit run, the combo box shows up but nothing in the downlist......
Since these macros listed only work when I click on a contact, how should I open up the userform combo box in a contact or after identifying the contact, and see what happens?
Make sense?
Here is the code per what you gave me as I posted the macro you can see earlier so you see the name etc.
Public lstNo As Long
Public Sub NewMessageUsingTemplate()
Dim oMail As Outlook.MailItem
UserForm1.Show
Select Case lstNo
Case -1
From_Lou_Stoler
Case 0
From_Lou_Stoler
Case 1
From_Lou_Stoler
End Select
End Sub
Private Sub ComboBox1_Change()
End Sub
So where do I test it? As under the VBA area and I hit run, the combo box shows up but nothing in the downlist......
Since these macros listed only work when I click on a contact, how should I open up the userform combo box in a contact or after identifying the contact, and see what happens?
Make sense?
Here is the code per what you gave me as I posted the macro you can see earlier so you see the name etc.
Public lstNo As Long
Public Sub NewMessageUsingTemplate()
Dim oMail As Outlook.MailItem
UserForm1.Show
Select Case lstNo
Case -1
From_Lou_Stoler
Case 0
From_Lou_Stoler
Case 1
From_Lou_Stoler
End Select
End Sub
Private Sub ComboBox1_Change()
End Sub