[AccessD] Attach Database Using SendObject

Charlotte Foust cfoust at infostatsystems.com
Wed Sep 17 18:27:19 CDT 2003


Outlook is definitely MAPI compliant.  That's what those annoying
security patches were all about. :o{

Charlotte Foust

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Wednesday, September 17, 2003 2:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Attach Database Using SendObject


Stuart:

Thanks.  I'll give it a try.  Is Outlook MAPI compliant?

Rocky

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, September 17, 2003 3:20 PM
Subject: Re: [AccessD] Attach Database Using SendObject


> On 17 Sep 2003 at 9:44, Rocky Smolin - Beach Access S wrote:
>
> > Very similar to what I use but I'm trying to get away from using 
> > Outlook.  That's why I though of SendObject because it should 
> > trigger whatever the user's default mail client is.  I think.
> >
> > Rocky
> >
>
> SendObject will only send objects which are in a database, not a 
> database or any other sort of file.
>
> My solution in this case (I stay right away from OE/Outlook whenever
> possible) is to Shell out to a little utility I wrote called MAPISend.

> You can download it (11KB) from http://www.lexacorp.com.pg Here's what

> I say about it on my software page:
>
> MAPISend is a simple Command Line utility to send messages (and
> attachments) via any MAPI compliant email system (such as Pegasus 
> Mail). You can use it in batch files or macros/modules in other 
> programs to automate emailing documents. If you run MAPISend without 
> any parameters, it will display a simple help screen.
>
> One use for MAPISend is to email MS Word documents easily (which you 
> normally can't do unless you use MS Outlook.) To do this, just put put

> this Macro in your Normal.dot template file and create a menu item or 
> toolbar button to invoke the macro:
>
> Public Sub send_document()
> Dim lngResult As Long
> If Documents.Count >= 1 Then
>   If ActiveDocument.Saved = False Then
>       ActiveDocument.Save
>   End If
>   lngResult = Shell("Mapisend /E /F " & ActiveDocument.Name) Else
>   MsgBox "No documents are open"
> End If
>
> End Sub
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System
> Support.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list