Sendobject a text file

[Stu]

I'm creating an application in Access 2003 and have a roster of people with
their e-mail addresses stored in a table. I would like to generate e-mail
messages for each one and have a text file included as an attachment. The
text file has nothing to do with Access or the data in it.

The SendObject action is what I have used in the past to send email messages
from within Access. However, the ObjectType, ObjectName, etc. parameters no
not allow for sending an object that resides outside of Access.

How can I generate e-mails from within Access that have an attached file
that resides outside Access?

Stu

 

[Cheryl Fischer]

You might want to consider Outlook Automation from within Access, as you
will have many more options. Here is a link with sample code that will get
you started:

http://tinyurl.com/2knwj

 

[Steven Parsons [MSFT]]

Hi Stu -

This is Steven from Microsoft Access Technical Support replying to your
newsgroup post.

I'm not sure how you got SendObject in prior versions of Access to pickup
and external file and attach it to the email before sending the message. I
do not recall any version of Access allowing the user to do that while
using the SendObject action or method. But if you have a sample of an
Access database that use to do that, I would be interested in looking at it.

The suggestion that you were given to use Outlook automation would be one
way to programmatically send an email message, including an attachment. For
example, please see (this works in Access 2003, even though this document
was written while using Access 2000):

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access
http://support.microsoft.com/default.aspx?scid=KB;EN-US;209948

With the email security built into Outlook, however, using automation will
always prompt the user whether they are sure they want to perform such as
task, and there will be no way to squelch this prompt. The user will be
required to click Yes, No, or Cancel. To avoid such a security message, you
may have to use Collaboration Data Objects (CDO) instead of the Outlook
object model. The following web page will tell you more about CDO:

OL2000: Developer Information About the Outlook E-mail Security Update
http://support.microsoft.com/default.aspx?scid=KB;EN-US;262701

Please let me know if this solves your problem or if you would like further
assistance. I look forward to hearing from you.

Sincerely,
Steven Parsons [MSFT]
Microsoft Access Product Support Services
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! (http://www.microsoft.com/security)