Hi, hope you can help me here I'm pulling my hair out with what i thought would be a simple matter.

I have a small acccess project that i want to automate as much as possible for the end user. So far it's been pretty straight forward. The latest hurdle i've come accross is being able to send an external file as an attatchment to an email recipient. I've had a look at the sendobject cmd but this only appears to work with (1) database objects, ie forms, reports etc and not external files. (2) unless the email to address is in the email programs address book i seem to get an error.

Someone suggested using mapi, someone else suggested CDO but thats as much information as they gave me. Ive tried with both but keep coming up with errors which i dont entirely understand (mainly because i aint a programmer and i'm trying to pick things up as i go along), the main thrust of the errors was that objects where required - i've added refernces to both mapi and CDO in the references bit and i can see the objects in the browser but i well and truly stuck.

Some gentle guidance and patience would be greatly appreciated.

Regards,
Noel.