E-mailing files using SendObject action

[Guest]

Does anyone know if it is possible to email an attachment which is not one of the available Object Type formats of the SendObject action (.xls, .rtf, .html etc) using the SendObject action. I am talking about using the SendObject action to automatically email a non-MS Access object such as a .pdf file in a certain directory, from within VBA from Access... thanks

 

[Cheryl Fischer]

No. SendObject is designed to send only Access objects or no object at
all.

You might want to investigate using Automation with Outlook. There is
sample code at the following links that can get you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881


Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm


--

Cheryl Fischer, MVP Microsoft Access

Does anyone know if it is possible to email an attachment which is not one

of the available Object Type formats of the SendObject action (.xls, .rtf,
..html etc) using the SendObject action. I am talking about using the
SendObject action to automatically email a non-MS Access object such as a
..pdf file in a certain directory, from within VBA from Access... thanks