Right am I am having a little trouble.
I am writing a VBA program in Excel (access restrictions you know, etc, otherwise I would use something a little more flexiable) and one of the requirements is to zip up a whole lot of files, and then send that zip to the mail program as an attachment.
However, that is the part I am having trouble with. Google is confusing, and althrough there are batch scripts, backends, and everything for every program under the sun BUT Lotus Notes I have yet to find a solution.
The solutions I have found require me to install a program, which will breach the security policy.
So far the ziping part is easy, and involves some very creative use of the Shell Command in Excel.
Now, if all the files that had to go into the Zip file were Excel files I could forget the whole thing and send the file directly, as the File --> SendTo --> Mail Recipiant as Attachment works, however there are some supporting files etc that need to go in PDF format.
Does anyone have any ideas or is implementing this part of the program not feeisable given the current tools I have?
If they were using Microsoft Outlook or something that supported mailto:x@y.com?Attach="C:\test.zip" I would be laughing, but no, it has to be the devil's own Lotus Notes.


LinkBack URL
About LinkBacks

Reply With Quote

