send a file via VBA in MS Access

[diepblauw]

I have a file C:\temp\abc.doc
I'd like to write VBA code for a button. When the button is clicked, the file abc.doc will be sent out as attachment via email. How to write such a script?

Thanks.

 

[hermanlaksko]

Try

http://www.helenfeddema.com/

she also has solutions to the above.

Rgds
Herman

 

[hermanlaksko]

For some odd reason the top part of my msg is missing.

I have a solution to this problem however its too large for this forum. If you are interested and Helen did not fix the problem drop your e-mail here an I shall forward it off-line.
Also note that due to security M$ has put a stop to this poss fra outlook 2k servicepack 1 onwards. After this your mails will only into the drafts box even though your code drop them into the outbox.

Herman

 

[diepblauw]

My email address is zonnebloem@email.com

I dropped my email here yesterday. But now it is not there. It's strange.

Plz send the code/form to me.

Thanks.

 

[mp9]

Alternatively, if Outlook is your mail client there's a feature-rich solution to this question at

http://www22.brinkster.com/accessory/modules/005.shtml