Creating OE e-mail from VBA won't add attachment.

[Kraeg]

I've got code in an Access database that creates an e-mail using the Outlook library. However, I need it to also be able to use Outlook Express.
I found this code (thanks DougP):

http://www.tek-tips.com/faqs.cfm?spid=705&newpid=705&sfid=537&CFID=72470965&CFTOKEN=58541598

that works, except it won't attach the file I want to send.

I checked the OE mail message command line; it takes To, CC, BCC, Subject and Body, but no attachments.

Does anyone know any way of attaching a file (using VBA)?

 

[Danifrog]

See

http://www.jephens.com/howtoemail.asp

 

[Danifrog]

Also

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q161088&