Search results for query: *

I think you should be able to use a message box as soon as you call a function. Hopefully this helps.

It looks like you could create some sort of function in your CognosScript macro that will do this for you. It should not be much more difficult than the explanation you have already given.

Option Explicit Sub Main Dim varDate as String varDate = "2003-05-04" MsgBox(Format(varDate, "m/dd/yyyy")) end sub

Why not just use the format command?

I've got some that take much, much longer

In your Send button Code, put the following: '-------Start of Code----------------------- Dim objGroupwise as object Dim objGWaccount as object Dim objGWmessage as object Dim objGWrecipient as object 'Dim objGWCC as object 'Dim objGWattachment as object 'only use CC and attachment if you...

I'm sort of familiar with using Novell GroupWise with this type of thing. If you would like to see that, let me know.

Here is what I've got. ImpDoc(n,2) ImpDoc(1,1) = "report name" Impdoc(1,2) = "Catalog name" ... ImpDoc(n,1) = "report name" Impdoc(n,2) = "Catalog name" Set ImpApp = CreateObject("CognosImpromptu.Application") ImpApp.Visible 1 for j = 1 to n...

Have you tried pulling each row in as an element of an array?

You would want to create a for loop in your macro and then execute the line: Set ImpRep = ImpApp.OpenReport (ImpRepPath & ImpDoc & ".imr", Prompt1) Using this, you would only have to enter the Prompt1 information one time, and can send it to the report as many times as you need to (the...

Option Explicit Declare Sub Email(Subject$, SendTo$, Body$, Attach$) Dim objGroupwise as Object Dim objGWaccount as Object Dim objGWmessage as Object Dim objGWrecipient as Object Dim objGWattachment as Object Sub Main() call Email(something,name,text,attachment) 'Call email function...

I have created a similar macro for emailing using Novell GroupWise and CognosScript. Let me know if you would like to see it. Chad

What I described earlier doesn't seem to work as well as I thought it would. I'll keep messing around and see what I can come up with.

I have the same type of problem. When I run my macro manually, it is strait butter. When I had it scheduled to run this morning at 5:00 am, it was still sitting there when I showed up to work. I think the problem has to do with impromptu having to be on the screen and be the active...

I wasn't able to do exactly what you are looking for, but I did come close. What I did was enter the email addresses in a String, separating them by commas(you could use semicolons, or whatever you want). I then wrote a subroutine to split the string into an array of names that the email...

Did you end up finding a way to add more than one recipient without calling the send_email function each time or adding a new line to the function for each new recipient? I've tried doing the same thing, using info from the novell page, but I still haven't got anything to work.