attachement with email

[Mark]

Hi All,

I am using
http://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-without-Security-Warning
to send an email with a report attached. My problem is I don’t know how to
get the report attached using his procedure. He has a procedure in the VB to
so it, but just over my head I guess.

How can I get an access report attached to the email using this procedure
(link above)?


Here’s what he has:

'Add any specified attachments
TempArray = Split(strAttachments, ";")
For Each varArrayItem In TempArray

strAttachmentPath = Trim(varArrayItem)
If Len(strAttachmentPath) > 0 Then
.Attachments.Add strAttachmentPath
End If

Next varArrayItem

 

[Piet Linden]

Hi All,

I am usinghttp://www.everythingaccess.com/tutorials.asp?ID=Outlook-Send-E-mail-...
to send an email with a report attached.  My problem is I don’t know how to
get the report attached using his procedure.  He has a procedure in theVB to
so it, but just over my head I guess.  

How can I get an access report attached to the email using this procedure
(link above)?

Here’s what he has:

'Add any specified attachments
                TempArray = Split(strAttachments, ";")
                For Each varArrayItem In TempArray

                    strAttachmentPath = Trim(varArrayItem)
                    If Len(strAttachmentPath) > 0 Then
                        .Attachments.Add strAttachmentPath
                    End If

                Next varArrayItem

Be reckless... create the list of attachments in a semi-colon
delimited string (e.g.
"Attachment1.doc;SomeXLFile.XLS;AnotherPPT.PPT")
so when you hit that lovely Split function, it can actually divide the
string into separate items... Open a code module, any module, and hit
F1. Say hi. Introduce yourself to the help file... there's a ton of
stuff in there to read...