Access to Groupwise

[DubboPete]

Hi all,

I piched a bit of code from the newsgroup that was sent in yrs ago, to kick
off Groupwise and send a table's contents in Excel format.

It all works great apart from two points that are pedantic for me...

Here's the code:

Private Sub Command125_Click()
DoCmd.SendObject acTable, "TblActivityResultsEQuIPFunction",
"MicrosoftExcel(*.xls)", "(e-mail address removed)", "", "", "Activity
Export", "", False, ""
End Sub

The email arrives at it's destination, with an Excel spreadsheet attached,
and all is fine and dandy - except for the sender. It defaults to the
Application Title, in this case from 'Squirt Database'.

Also, because Exchange acts as the go-between from Access to Groupwise, it
prompts me for a profile, which defaults to "Novell Default Settings", and
on clicking ok, it does the job perfectly.

I would just like to know if anyone has a fix for changing the sender from
'application title' to a username stored in a field called - rather aptly -
[username]; and
if anyone knows how to include the "Novell Default Settings" somewhere in
the code, so that it bypasses that Exchange step...

many thanks in anticipation!

DubboPEte

 

[Tim]

DubboPete,
I used this link here to help with sending data from access via groupwise.
http://www.granite.ab.ca/access/email.htm

I believe that it'll send the email with whomever is currently logged in to
groupwise otherwise it'll use the default login. I hope that helps.

Tim