sendobject

[ReidarT]

I want to automate an email-shipment.
When I use the SendObject, it works OK when I want to send a table, query
and so on.
I want to send a zipped file and that's the problem.
I try
docmd.sendobject , zipfile , , "emailreceipient", "subject", "bodytext"
I don't want to bind this to Outlook-clients, because there are other
systems involved as well.

regards
reidarT

 

[Rick Brandt]

I want to automate an email-shipment.
When I use the SendObject, it works OK when I want to send a table, query
and so on.
I want to send a zipped file and that's the problem.
I try
docmd.sendobject , zipfile , , "emailreceipient", "subject", "bodytext"
I don't want to bind this to Outlook-clients, because there are other
systems involved as well.

Sorry, SendObject only sends Access objects. It cannot be used to attach
external files to the message. You can automate MAPI/CDO/SMTP to send mail
without having to use Outlook (assuming those libraries exist on your system
or can be installed with your package).