[AccessD] Attaching a file to an email

Stuart:

Beautiful.  Works like a charm.  And what tech support!  Did you write this
in VB?

Thanks and regards,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- 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 6:53 PM
Subject: Re: [AccessD] Attaching a file to an email


> On 18 May 2004 at 16:30, Rocky Smolin - Beach Access S wrote:
>
> > 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")
> >
>
> Delimit them with semicolons ";" without any leading or trailing spaces.
>
>     & "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?
> >
>
> MAPISend - the full path is required unless it is in the *current*
> directory when you shell out, or it is your Path (otherwise the Slee
> command won't find it)
>
> Attached Files, yes - the full path is required.
>
>
> -- 
> 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
>