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

Topic

New Reply

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

Reply | Quote

Replies

Maybe this might work:

Activeworkbook.SendMail “Receipients”,”Subject”

(hoping it will start your default mail client).

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote