[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.