Pookiemeister
Well-known Member
- Joined
- Jan 6, 2012
- Messages
- 623
- Office Version
- 365
- 2010
- Platform
- Windows
I have inputbox that asks the user, how many people they want to send an email to? Depending on the number of people, it will loop a userform that many times allowing the user to enter in the different email addresses. The value will be stored into a string separated by a semicolon.
Questions:
1. Is there a way to count the number of emails entered?
2. Then display those email addresses in a message box (for test purposes). Each email on its own line. Using the vbnewline.
3. If the user wanted to add a new email address, it looks at the values in the string and if the person they want to enter is already included, display a message that states something like user already entered.
I thought about storing this an array, but I've never done this before. Is there a better method to do what I am wanting? Thanks
Questions:
1. Is there a way to count the number of emails entered?
2. Then display those email addresses in a message box (for test purposes). Each email on its own line. Using the vbnewline.
3. If the user wanted to add a new email address, it looks at the values in the string and if the person they want to enter is already included, display a message that states something like user already entered.
I thought about storing this an array, but I've never done this before. Is there a better method to do what I am wanting? Thanks
Last edited: