Sending an Attachment with Docmd.SendObject

J

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?
 
M

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
 
J

Joe Hopkins

Turtle

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

Joe
 
M

MacDermott

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