email a file

J

JED

Is there a way to email a file in Access 2000/2002 ? The "SendObject" will
only attach an object within Access (eg. report), but not an external file. I
have a situation where a report was saved as a ".SNP" file by using the
"OutputTo". However, at a later time I would like to email that file. I
cannot recreate & email it using the "SendObject" since the data may have
changed in the meantime.
 
R

Rick Brandt

JED said:
Is there a way to email a file in Access 2000/2002 ? The "SendObject"
will only attach an object within Access (eg. report), but not an
external file. I have a situation where a report was saved as a
".SNP" file by using the "OutputTo". However, at a later time I would
like to email that file. I cannot recreate & email it using the
"SendObject" since the data may have changed in the meantime.

SendObject does not support that in any version of Access. You would have
to automate an external messaging library like Outlook or CDO.
 
T

Tony Toews [MVP]

JED said:
Is there a way to email a file in Access 2000/2002 ? The "SendObject" will
only attach an object within Access (eg. report), but not an external file. I
have a situation where a report was saved as a ".SNP" file by using the
"OutputTo". However, at a later time I would like to email that file. I
cannot recreate & email it using the "SendObject" since the data may have
changed in the meantime.

There are many different options depending on your environment.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top