VBA Lotus Notes??? 10

[mbarnett]

Hi All,

I have an email I need to send every night, It contains the same name and is located in the same folder (it is created by a macro) is there a way to automatically send the email using VBA. I used to do it in my old job but that was with outlook. How can I do it or write it using Lotus Notes? Any Ideas????

 

[Rofeu]

Hi,

first of all: tbl, excellent bit of code! Much better than that Sendkeys I've been using so far. Let me give you another star.

I've one question about calling the different parts of the email.

I need to send a FTP Memo programatically and everything is working okay with the code above and changing the Form to "FTP Memo", but how do I populate the section where the addresses for the people to send a link to go? (or better yet: is there a library where the properties and methods like i.e. .sendto and .CREATERICHTEXTITEM are listed?)

Any help and/or references are appreciated.

Cheers,

Roel

 

[tbl]

Hi Roel,
probably just me being thick, but I'm not quite clear what you are missing. The existing code enables the "Send to" field to be filled in for multiple addressees and also to enter text into the body of the mail. What else is there ?

Richard

 

[Rofeu]

Hi, Richard,

within Notes, one can also send so called FTP Memo's. These basically send the email to a generic database and links to the mail+attachment to a group of people (as not to send huge files to a lot of people). The setup here is:

Send To: which is the database where the email has to go
Subject: as normal

Links send to: the addresses of the people that need a link

Body of Text

If I change "Memo" to "FTP Memo" everything works as it should with the exception, that no links are send. This is the field I was talking about.

I hope this makes things clearer.

Roel

 

[tbl]

Thanks Roel for the explanation.
I've never explored this aspect of Notes, but if you open a new Excel book with a VBA module in it and link references to everything Lotus Notes, you can look at all of the available Domino objects in the Object Browser. (Not that that is a very enlightening experience)
I guess that you need to create a new object for your link.

Richard

 

[HughLerwill]

Roel,

This may be of interest;

http://www-12.lotus.com/ldd/doc/lotusscript/lotusscript.nsf

regards Hugh