Mail Dashboard via Lotus Notes from Excel using VB

[Simayan]

Hi,

I have couple of Dashboards linked from Various files, along with hyperlinks mentioned for the respective Source files.

Now I have put this file in my computer's link(Mentioned below), So that every morning when I open excel this file gets open, so that I can track the progress of various activities.

C:\Users\Simayan\AppData\Roaming\Microsoft\Excel\XLSTART

Now I wantr a vb script, so that post I see all in track/after few formatting/modification; mail this file to a certain list ( To & Cc) along with this file as attachment.

Please help.

N.B. if any one already have a vb script for mailing via lotus notes using excel, please let me know, rest I can design

 

[Luke M]

Hi Simayan,

I don't have a lot of experience with Lotus Notes, but did have a thread awhile ago where we did soomething. Start reading here:
http://forum.chandoo.org/threads/email-notification-with-row-values.22737/#post-137638

and see if you can adapt the code? It shows at least how to create the Lotus object and send an email with attachments. Sorry I don't have more.

 

[bobhc]

This link may assist you


http://www.rondebruin.nl/win/s1/notes/notes.htm~


.