Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Location
    Port Talbot, Wales
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intigrating GroupWise 5.5 and Excel 97 (Excel 97)

    Every week one of my colleagues at work has to send out 41 different files to 41 different offices throughout the UK, this takes alot of time and effort that could be used more productivly. I was just wondering if anyone knows how to intigrate GroupWise 5.5 and Excel 97 so i can have a list of offices and a list of the office managers (e.g. attached.) and have an excel macro to send the correct file (the file names are in the format "OfficeName - WeekBeginDate.xls") to the correct office manager automatically. I have knowledge of intergrating MS Office applications but thats as far as it goes. I have no knowledge of API's etc. All help on this would be much appreciated.

    Thanks in advance
    Jambo

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intigrating GroupWise 5.5 and Excel 97 (Excel 97)

    Maybe this might work:

    Activeworkbook.SendMail "Receipients","Subject"

    (hoping it will start your default mail client).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intigrating GroupWise 5.5 and Excel 97 (Excel 97)

    In a module set a reference to the GroupWise type library

    Add the following code:

    'Begin Code
    With New GroupwareTypeLibrary.Application
    Do

    strEmailAddress = 'Place code here that will loop through your addresses.

    With .Login
    With .MailBox.Messages.Add(Class:="GW.MESSAGE.MAIL")
    .Subject.PlainText = "Place subject here"
    .BodyText.PlainText = "See attachment."
    .Recipients.Add strEmailAddress
    .Recipients.Resolve
    .Attachments.Add "File Location .xls"
    .Send
    End With
    End With


    Loop Until .EOF ' Your address file

    .Quit

    End With

    'End Code

  4. #4
    Star Lounger
    Join Date
    Nov 2002
    Location
    Port Talbot, Wales
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intigrating GroupWise 5.5 and Excel 97 (Excel 97)

    thanks pieterse, your little one liner worked like a charm, until i started sending files with long filenames, then it kept trunkating them. Accdb, tried your bit of code and it works perfeclty, im coding it into my SQL queries at the moment. That should save me a few hours a week. Thanks again you lot, i have learnt more here than any of the books i've read.

    Thanks again
    Jambo

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intigrating GroupWise 5.5 and Excel 97 (Excel 97)

    Jambo,

    Try using the attached XL file. It works with Outlook98 but has not been test on any other versions. You can create up to four paragraphs of text for the body of the E-mail message and attached up to five files (anytype). The instructions are included in the XL file.

    John

  6. #6
    Star Lounger
    Join Date
    Nov 2002
    Location
    Port Talbot, Wales
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Intigrating GroupWise 5.5 and Excel 97 (Excel 97)

    Guess what guys, i need your help - again. This time i need to create a GW address book by rolling through data pulled from our Human Resource database. I have a list of the people i need to be in the address book in a excel worksheet. There are about 5000 of them for this particular job but there will be other jobs. I would like to cycle down the list (pulled from a SQL Database) and add the names to a GW address book and then save the address book. Anyone got any idea how to do this? Please help

    Cheers
    Jamie

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •