[AccessD] Attaching a file to an email

Stuart:

Thanks.  Got it.  It's working, too! For one file.

Is there a way to attach more than one file?

This works:

lngResult = Shell("C:\Clients\SleepDoc\Mapisend.exe /A BchAcc at san.rr.com /S
" _
    & "SleepDoc Data From " & gstrPatientName & "/E /F" _
    & "C:\Clients\SleepDoc\" & gstrPatientName & "1.TXT ")

but this doesn't:

lngResult = Shell("C:\Clients\SleepDoc\Mapisend.exe /A BchAcc at san.rr.com /S
" _
    & "SleepDoc Data From " & gstrPatientName & "/E /F" _
    & "C:\Clients\SleepDoc\" & gstrPatientName & "1.TXT, " _
    & "C:\Clients\SleepDoc\" & gstrPatientName & "2.TXT")

Also, it appears to need the full path to find Mapisend.exe and the full
path to find the attachment files.  Yes?

Regards,

is

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, May 18, 2004 3:01 PM
Subject: Re: [AccessD] Attaching a file to an email


> On 18 May 2004 at 8:44, Rocky Smolin - Beach Access S wrote:
>
> > Dear List:
> >
> > I would like to export a couple of text files from an app and hook
> > them to an email, though code.  I'm using DoCmd.SendObject because it
> > looks like it's independent of the mail client onthe user's machine.
> >
> > But is there a way to attach a file to the email which is generated by
> > DoCmd.SendObject?
> >
>
> As  others have said, yopu can't do it with Docmd.SendObject. That's
> one of the reasons I wrote MAPISend.
>
> "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. "
>
> You can download MAPISend from http://www.lexacorp.com.pg (follow the
> "Free Software" link). It's an 11KB zip file.
>
>
>
>
>
>
>
>
>
>
>
> -- 
> 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