S
SusanV
Requirement for weekly project status is to send 3 different reports as
snapshot files via email. I got this mostly automated using a macro to
create the 3 reports in the proper folder on the server. Works fine except
the users have to manually zip the 3 snp files, rename the file (both name
and extension) then email it to a half dozen people. Last week someone
forgot to rename the file extension and so the attachment was stripped by
one of the remote office's antivirus. This week someone was left out of the
To: line and didn't get their copy (and of course this was a high
mucky-muck).
So now management has asked if I can automate the entire process - click a
button and poof here's the email ready to hit send. Well... at this point, I
think I can do *most* of it. I know how to use SendObject to populate the
subject, attach the file, set addresses etc.
What I can't seem to manage is creating the zip file and then renaming it.
I'm sure I could write an old fashioned batch file using pkzip to do this
via RunApp but I really want to learn how to get this step via code so that
I can get rid of the macro altogether, and not have extraneous cmd or bat
files floating around...
Every day I learn stuff here and it seems I'll never know half!
Thanks in advance,
SusanV
snapshot files via email. I got this mostly automated using a macro to
create the 3 reports in the proper folder on the server. Works fine except
the users have to manually zip the 3 snp files, rename the file (both name
and extension) then email it to a half dozen people. Last week someone
forgot to rename the file extension and so the attachment was stripped by
one of the remote office's antivirus. This week someone was left out of the
To: line and didn't get their copy (and of course this was a high
mucky-muck).
So now management has asked if I can automate the entire process - click a
button and poof here's the email ready to hit send. Well... at this point, I
think I can do *most* of it. I know how to use SendObject to populate the
subject, attach the file, set addresses etc.
What I can't seem to manage is creating the zip file and then renaming it.
I'm sure I could write an old fashioned batch file using pkzip to do this
via RunApp but I really want to learn how to get this step via code so that
I can get rid of the macro altogether, and not have extraneous cmd or bat
files floating around...
Every day I learn stuff here and it seems I'll never know half!
Thanks in advance,
SusanV