Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform help needed
Hi,
I have a macro that sends emails. The send email feature is in a loop so it could possibly send out multiple emails to multiple addresses. Before the email is sent, I have a Userform that pops up and tells you what information you are about tho send. I hit Continue (which does "Unload Me") and the email is sent. Let's say there are two emails that are going to go out though. The form pops up, the email is sent, and then..... nothing seems to happen. As soon as I click on Excel though, the next dialog box pops up (with the info that will be sent in the second email) and everything goes out fine. So, I'm not sure why the focus for the second user form is lost? I've tried a few things, but can't figure it out. I bring up the form like this: UserForm1.TextBox1.MultiLine = True formbody = "To: " & contactArray(z) & vbCrLf & "Subject: " & strsub & vbCrLf & vbCrLf & formbody UserForm1.TextBox1.Value = formbody UserForm1.Show Thanks in advance for any advice/help with this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform help needed
It would be more helpful to see the entire code loop.
"Corey G" wrote: Hi, I have a macro that sends emails. The send email feature is in a loop so it could possibly send out multiple emails to multiple addresses. Before the email is sent, I have a Userform that pops up and tells you what information you are about tho send. I hit Continue (which does "Unload Me") and the email is sent. Let's say there are two emails that are going to go out though. The form pops up, the email is sent, and then..... nothing seems to happen. As soon as I click on Excel though, the next dialog box pops up (with the info that will be sent in the second email) and everything goes out fine. So, I'm not sure why the focus for the second user form is lost? I've tried a few things, but can't figure it out. I bring up the form like this: UserForm1.TextBox1.MultiLine = True formbody = "To: " & contactArray(z) & vbCrLf & "Subject: " & strsub & vbCrLf & vbCrLf & formbody UserForm1.TextBox1.Value = formbody UserForm1.Show Thanks in advance for any advice/help with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Userform Needed | Excel Programming | |||
Userform help needed | Excel Programming | |||
UserForm code help needed. | Excel Programming | |||
UserForm code help needed. | Excel Programming | |||
Userform Formula Help Needed | Excel Programming |