Hi all,

I know it is possible to send email with Access, but can one also automate the attachments?
Question has been asked a lot I know...
I've searched Google but *all* answers that work use Outlook or commercial apps?

So I have not been able yet to automate the attachment issue using Outlook Express.
Any ideas or 'new' insight?
(Using Access '97 or Access 2000)

TIA
Arno R

"Arno R" <arracomn_o_s_p_a_m@tiscali.nl> wrote in
news:blsnap$lak$1@reader1.tiscali.nl:
[color=blue]
> Hi all,
>
> I know it is possible to send email with Access, but can one also
> automate the attachments? Question has been asked a lot I know...
> I've searched Google but *all* answers that work use Outlook or
> commercial apps?[/color]

Search some more.


--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

while or for
MapiMessages.AttachmentIndex = x ' order number
0,1,2,3....
MapiMessages.AttachmentName = Name
MapiMessages.AttachmentPathName = PathName
MapiMessages.AttachmentPosition = x ' attachment number
0,1,2,3...
MapiMessages.AttachmentType = 0 ' data file
x=x+1
wend or next
Jordan Gomila