Cycle through Choices as Variant

[Solarissf]

Hi Guys,

So I have this pretty big program and I have a question about one part.
Basically for each case it is sending an email to multiple people.
My question is, when it goes to each case does this automatically know to do every email in the list. The reason I ask is because I noticed every once in a while it was sending to people not even in that particular case. Does it have something to do the the number I'm putting in the Variant part?
How do I make sure it sends to only people I specify in each case?

THANKS

Please Login or Register  to view this content.

[Leith Ross]

Hello Solarissf,

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

Sincerely,
Leith Ross

[Solarissf]

thank you
problem explained alittle more.
In Case 4 I have 4 emails it should goto, and it does.
In Case 5, I have 3 emails, but the macro is still emailing to 4 people, and it seems that it picks a random person. Can someone please help me to figure out why it is emailing extra people?

THANKS!!!

Please Login or Register  to view this content.