|  | email a file | | |
| | | JED |  |
|  Posted: Sun Sep 21, 2008 1:32 pm Post subject: email a file |  |
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. |
| |
| | | Rick Brandt | |
| | Posted: Sun Sep 21, 2008 2:11 pm Post subject: Re: email a file | |
JED wrote:
| Quote: | 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.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com |
| |
| | | Tom Wickerath | |
| | Posted: Sun Sep 21, 2008 3:01 pm Post subject: RE: email a file | |
Hi Jed,
Look on page 19 of a document that I call Access Links.doc, for the topic
"Late Bound code for Outlook to send several file attachments." You are
welcome to download a zipped copy from here:
LINK
Tom Wickerath
Microsoft Access MVP
LINK
LINK
__________________________________________
"JED" wrote:
| Quote: | 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. |
|
| |
| | | Tony Toews [MVP] | |
| | Posted: Sun Sep 21, 2008 4:32 pm Post subject: Re: email a file | |
JED <JED@discussions.microsoft.com> wrote:
| Quote: | 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
LINK
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
LINK
Tony's Microsoft Access Blog - LINK |
| |
|
|
