automate emailing a file

[Guest_imported]

I would like to be able to email a file with a command button in Access from a form. The problem we are having is with our email server Netscape. So the solution we are looking for would take the file directly from Access and send it to the email server directly. This would involve VBA. Does anyone know of precompilied modules that would do this service? Or know of a good place to search for precompiled modules?

Any ideas or comments would appreciated to lead me in a new direction. Thanks!

 

[DougP]

See these 2 FAQ's
faq181-493

faq705-537

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[Gzep]

How about the library Msoutl9.olb that lets you create an office 2000 outlook object, and interact with it. So far my experience with it is using an exchange server, but it may be worth a look. Check for the file in your windows\system dir. If registered it needs to be referenced from Access, and lists as 'Microsoft Outlook 9.0 Object Library'.
try also:

http://www.microsoft.com/outlookdev/articles/movs105.htm

Luck,
Gzep.