Programmer_1
New member
- Local time
- Yesterday, 21:08
- Joined
- May 19, 2008
- Messages
- 1
I have a question regarding Groupwise email and integrating it with Visual Basic.
I am trying to set up a VBA application that will basically create a copy of an excel worksheet and also email it to destination clients. The problem is that it needs to be sent using the "delayed send" option in Groupwise. In this office, we deal a lot with sensitive information that cannot be published until a specified date and time. Are there commands that we can use upon execution of the VBA macro (in VBA) that will open up Groupwise, allow us to set the values for the "delayed send" and then continue the execution of the macro?
Be advised that I know how to embed a command in VBA to send an email in Groupwise. I just don't know how to open up Groupwise in the VBA module to make adjustments to the delay send (i.e. manually set the date and time for the message to be sent) and then have the macro continue executing.
Your response will be appreciated.
I am trying to set up a VBA application that will basically create a copy of an excel worksheet and also email it to destination clients. The problem is that it needs to be sent using the "delayed send" option in Groupwise. In this office, we deal a lot with sensitive information that cannot be published until a specified date and time. Are there commands that we can use upon execution of the VBA macro (in VBA) that will open up Groupwise, allow us to set the values for the "delayed send" and then continue the execution of the macro?
Be advised that I know how to embed a command in VBA to send an email in Groupwise. I just don't know how to open up Groupwise in the VBA module to make adjustments to the delay send (i.e. manually set the date and time for the message to be sent) and then have the macro continue executing.
Your response will be appreciated.
