Hi All,
I have a script that either sends or displays several emails, however, when testing additions to the script, I would like to declare one variable to return .Send or .Display, to avoid having to change several sections from .Send to .Display.
I've tried
Any advice would be greatly appreciated
Please Login or Register to view this content.
Many thanks
The simplest way would be to use something like a Boolean variable and then just test it:
Please Login or Register to view this content.
you'll need to trigger it somehow.
If you run the script from a userform, you could add an object (listbox with 2 items , 1 checkbox "Send" , combobox with choices) to select the required action.
Set that action to the variable so it has the chosen action before you actually run the mailing part.
The boolean option from #2 (rorya) could be easely be added to a checkbox
Even a little help can be a big help !!
1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
4. Use [CODE] [/CODE] tags to illustrate your code: see here
Makes sense, just couldn't think this morning, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks