Email-attaching a file Within Access

[leckie]

I am successfully formatting an email using data on a form but can't seem to find the code to tell outlook to attach a txt file

any help muchly appreciated

 

[StarScream]

I am trying to do the something similar. I want to be able to click a button on a form to automatically send the email. The email should pull information from the form inputs.

What code are you using to send an email based on information from a form? Thanks. PJ

 

[RichieSimonetti]

You could use this free-great dll to send mails with attachments whithout take care of which e-mail client you have:

http://www.freevbcode.com/ShowCode.Asp?ID=109

 

[leckie]

Starscream,

I Have now found all the code to enable emailing and attaching files within access at the press of a button, if you still need a copy of the code let me know...

Leckie

 

[rphbrew]

I would like a copy of the code that will let me add multiple attachments to an email from within access.

Specifically I want to send access reports to multiple users.

 

[RichieSimonetti]

As i told you, use the code from freevbcode's site.

 

[rphbrew]

I downloaded the file, but since I am not a programer I am not sure how to install the program and use it.

any help would be appreciated.

 

[RichieSimonetti]

The site have a source code example on it, didn't you see it?

 

[RichieSimonetti]

You have to add the code in a module of your db and set the references to the dll mentioned there.