Access and Novell GroupWise e-mail

[Eric @ SEASH, Evansville]

Is there any way to have Access automatically send a report (or query) as an
attachment to an email when Novell GroupWise is the email system ? I can't
seen to get the "SendObject" command in a macro to work.

Thanks !

 

[Tom Wickerath]

Hi Eric,

First, I recommend weaning yourself away from macros. You won't be able to
do a lot of things with macros that you can do with VBA code. That being
said, take a look at the following thread, which includes 16 messages:

http://groups-beta.google.com/group..._frm/thread/11c6b073b203dd75/64e323546c18867d

I ended up working with Bryan off-line for the next couple of days on this
issue, until he had a solution that worked. While he did not post a followup
in his case, the code to automate Lotus Notes looked like this:

**********************
Sent: Friday, February 04, 2005 8:29 AM
Subject: Fixed it!!!!!!!!!!!!!!!

Tom,

I tried another route and it fixed the problem. I can now send the string
of addresses!! I've enclosed the completed code for this "little" email
detail!!!!!!!!! Note the new module on the end. Your help has been
invaluable. Thanks so much!!

On Error GoTo ProcError

If Me.Dirty Then
Me.Dirty = False
End If

Dim Recipients As String, strBody As String
Dim SendTo As String, attachpath As String
Dim Session As Object, db As Object, doc As Object, rtitem As Object, tmp As
Object

Set Session = CreateObject("Notes.Notessession")
Set db = Session.GetDatabase("", "")
Call db.OPENMAIL
Recipients = BulkEmail()

<snip>

********************************

So, you can see from the above that he was using late bound code (ie. Dim
Session As Object). As it turns out, Lotus Notes required an array of
recipients names. The OP had most of the required code from some other
source. My suggestion to you is to search the Novell website (perhaps under
support) for code samples to automate GroupWise using VBA code. If you can
find such a procedure, then many of the people who are regulars in this
group, including myself, will be in a much better position to offer you help.
We won't be able to test the actual code (unless someone has GroupWise
installed), but we can coach you on the next steps to take.

Good Luck,

Tom
________________________________________

:

Is there any way to have Access automatically send a report (or query) as an
attachment to an email when Novell GroupWise is the email system ? I can't
seen to get the "SendObject" command in a macro to work.

Thanks !

 

[Tony Toews]

Eric @ SEASH, Evansville

Is there any way to have Access automatically send a report (or query) as an
attachment to an email when Novell GroupWise is the email system ? I can't
seen to get the "SendObject" command in a macro to work.

As Tom states you'll have to move to VBA which can be daunting.

There is a GroupWise page at the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tom Wickerath]

Yes, learning VBA code can be a bit daunting, but it can also be very
rewarding. Consider the following quote from "Inside Relational Databases,
2nd Edition, by Mark Whitehorn and Bill Marklyn, published by Springer, p
151):

< Begin Quote>
"Macros offer the next level down, extending the functionality of the GUI.
Macros are still limited, however, and do not provide anything like the
enormous flexibility of a programming language. Both the macro and the
programming languages take some effort to learn and, surprisingly, often
require relatively different skills; in other words, a good working knowledge
of macros may not make it much easier to convert to using the programming
language. Perhaps even more surprisingly, I do not believe that programming
is fundamentally more difficult to learn. Macros are easier to use but not by
orders of magnitude."

and

"If you are new to RDBMSs, I suggest (with as much deference as possible)
that you may well not be in a position to judge whether you need macros or
programming. In that case, my advice is clear. Unless you are sure that your
needs really are simple, don't bother learning to use macros. Once you find
that you need more than the GUI offers, go straight to the programming
language. In this way you avoid the pain of climbing one learning curve only
to discover that the view from the top is unsatisfactory and another climb
awaits you."

</ End Quote>

Eventually, with enough practice, you should start having more and more
successes with VBA. There's lots of helpful people in this newsgroup who can
assist you with problems that you experience with your code.

Tom
____________________________________________