Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goatnorm
  • Order by date
  1. goatnorm

    Impromptu Macro

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

    Date calculation for Public Holidays in Cognos Script

    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.
  3. goatnorm

    Adding a 0 to the day for dd/mm/yy

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

    Adding a 0 to the day for dd/mm/yy

    Why not just use the format command?
  5. goatnorm

    tim

    I've got some that take much, much longer
  6. goatnorm

    Start GW 6.0-6.5 with command line or alternative with API

    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...
  7. goatnorm

    Placing email in 'Sent Items' folder

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

    Macro Question

    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...
  9. goatnorm

    getting resultset from sp within a macro

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

    Macros and prompts

    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...
  11. goatnorm

    Sending email with CognosScript

    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...
  12. goatnorm

    Sending email with CognosScript

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

    Macro waits without running!

    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.
  14. goatnorm

    Macro waits without running!

    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...
  15. goatnorm

    GW-Mail over VBA in Access, with more than two recipients!

    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...
  16. goatnorm

    GW-Mail over VBA in Access, with more than two recipients!

    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.

Part and Inventory Search

Back
Top