Sending email with attachement using VBA in Access2002

[huan]

Hi,

I am creating an email sending function in Access2002
using VBA. I can use shellexecute API to send email.
However, I could not find how to send an email with an
attahement which is MS word file.

Does anybody have sample code to send email with
attachement?

Thanks in advance.

Regards,

huan

 

[Lars-Eric Gisslén]

huan,

I suppose you are using the mailto: command in ShellExecute, right?

If that's the case you will not be able to add an attachment. The mailto:
command does not support attachments. The only parameters you can fully rely
on is the 'subject' and 'body' parameters. For further information about
mailto:, take a look at the RFC2368 document.
(http://ftp.sunet.se/pub/Internet-documents/rfc/rfc2368.txt )

Regards,
Lars-Eric