Andy Lacey
andy at minstersystems.co.uk
Sat Aug 6 02:23:26 CDT 2005
Dan's right. Can't use SendObject in a case like this. If your email client is Outlook you can use the Outlook object to do it though. I can send you an example if you want. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters > Sent: 05 August 2005 23:37 > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] SendObject > > > Barbara, > > I'm pretty sure that the DoCmd.SendObject command can only be > used to send objects that are a part of the Access database, > when the command is used within an Access database. To send > a different file, you'll need to use something else - like > SMTP email. An example of this is vbSendMail.dll, available > from FreeVBCode.com. > > The help file for SendObject is pretty good. > > Dan Waters > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Barbara Ryan > Sent: Friday, August 05, 2005 1:32 PM > To: Access List > Subject: [AccessD] SendObject > > I've used Docmd.SendObject to email Snapshot files. I now > need to email a .txt file and am having problems. There > doesn't appear to be an object type for text files. > > Any ideas? > > Thanks, > Barb Ryan > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >