Sending an Attachment with Docmd.SendObject

[Joe Hopkins]

I have an Access97 application and heavily use the
SendObject code to email candidates. I would like to be
able to have the option to attach a selected document file
at certain times. Can anyone tell me how to code this in?

 

[MacDermott]

The only way to send an attachment with SendObject is to send an actual
object (form, table, query, report) from your database.
If you want to attach a separate file, you must use significantly more
complex code, automating your e-mail application.

HTH
- Turtle

 

[Joe Hopkins]

Turtle

Thanks for responding back. Where do I find the more
complex code, if it exists.

Joe

 

[MacDermott]

Assuming you're using Outlook, you could Google on some combination of
Access, Outlook, and Automation...