SendObject Action

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I want to use SendObject Action to send an e-mail
with attachments. There's a mention of Outlook Express
being MAPI compliant in XP HELP, which is contrary to my
previous understanding. Does anyone know if it is? If not,
I then assume one would use MS Outlook?
Thanks Bill
 
Bill said:
I want to use SendObject Action to send an e-mail
with attachments. There's a mention of Outlook Express
being MAPI compliant in XP HELP, which is contrary to my
previous understanding. Does anyone know if it is? If not,
I then assume one would use MS Outlook?
Thanks Bill
Click to expand...

Unless your attachments are Access objects, you can't use SendObject to
e-mail them. But it actually is possible to send them using Outlook
Express. See the Lyle Fairfield's code at

http://ffdba.com/downloads/Send_Mail_With_Outlook_Express.htm

I've tested it and it works.

Probably most people use Outlook for this, though, because you can
easily automate it. Have a look at Tony Toews' Access E-mail FAQ page,
at http://www.granite.ab.ca/access/email.htm .
 
Dirk,
I might be heading for the edge of the cliff...

I need to automate via a user command button to
zip their "back-end" mdb and send it to a distribution
list taken from the applications user properties.

Under normal circumstances, I would use WinZip in
batch mode (unless you know of a better way) to
zip the otherwise voluminous database. (I still have
to learn how to invoke WinZip from VBA, but I
have the idea that it isn't too involved.) However,
there's not much use in proceeding with the zip
process until I know how to get the zip file attached
to an e-mail via MAPI .

Any help along these lines would be GREATLY
appreciated.

Bill
 
Bill said:
Dirk,
I might be heading for the edge of the cliff...

I need to automate via a user command button to
zip their "back-end" mdb and send it to a distribution
list taken from the applications user properties.
Click to expand...

That doesn't sound too hard. You'll probably want to make sure that all
connections to the back-end are closed when you do this, or at least
that no one is actively updating the database.
Under normal circumstances, I would use WinZip in
batch mode (unless you know of a better way) to
zip the otherwise voluminous database. (I still have
to learn how to invoke WinZip from VBA, but I
have the idea that it isn't too involved.)
Click to expand...

I gather that WinZip has a command-line interface, so you should be able
to use the Shell function to do that. Maybe you'll want to use the
ShellWait function from the Access Web. I think there may also be a
freeware zip compression library out there, also, but why not use WinZip
if you have it available?
However,
there's not much use in proceeding with the zip
process until I know how to get the zip file attached
to an e-mail via MAPI .

Any help along these lines would be GREATLY
appreciated.
Click to expand...

The links I gave you should help you with that.
 
Thanks Dirk, good input.

I'm out of town for a couple of days, but I'll resume this task
as soon as I return... probably this weekend. If you don't mind,
you might check this thread in several days, as I will post back
whatever I encounter.

Thanks again,
Bill
 
Lyle's code works great. All I have to do now is study how
to use WinZip in command line mode and I can zip the back-end
MDB using SHELL.
Thanks,
Bill
 
Dirk,
I'm not familiar with: "ShellWait function from the Access Web".
Is that a special version of Shell?
Bill
 
Dirk,
I have in fact implemented the use of Terry Kreft's ShellWait
to launch WinZip in line-command mode followed by
Lyle Fairfield's SendWithOE to send the zipped file. It all
works very well.
Thanks agian for your help.
Bill
 
Bill said:
Dirk,
I have in fact implemented the use of Terry Kreft's ShellWait
to launch WinZip in line-command mode followed by
Lyle Fairfield's SendWithOE to send the zipped file. It all
works very well.
Click to expand...

Oh, very good. When you said you had a followup, I thought you meant
another question. said:
Thanks agian for your help.
Click to expand...

You're welcome.
 
Back
Top