Lotus Notes and MS-Excel (97 SR2i)

Topic

New Reply

Hello All

I have written a VBA routine that e-mails using Lotus Notes. It works OK but I can’t have multiple recipants in the To: CC:, or BCC fields.

Anyone knows why? Any one knows a Lotus Notes developer who knows VBA?

Any one who would like to see the code I will send you a clean copy if you send me your e-mail, or maybe some one can tell me how to send a workbook to the list.

Thanks

Wassim

Reply | Quote

Replies

I’d be interested. Can you post your code here in the lounge?

Reply | Quote

Catharine

I would clean it up and post it over the weekend. But do you mean just copy and paste the code in a message or would you want me to attach a working workbook. I don’t know how to do that, I am still VERY new to this list, and I don’t know the protocol.

Thanks

Wassim

Reply | Quote

When you are in the message edit screen, there is a text ox under the edit box that is labeled “Attach a file – 100k Max.” under the edit box. There is a Browse button to the right of the text box. You can either type in the path and file name of the file or click on the Browse button and find your file. If you use the Preview button to look at your message before posting it, you will have to do this again in the Preview window.

Reply | Quote

Wassim, not sure if you had posted the VBA code for invoking Notes but I would be interested

Reply | Quote

Wassim,

my apologies for missing this the first time round. The trick is to treat multiple recipients as an array.

Dim MyRecipients As Variant
MyRecipients = Array(“brooke@work”, “brooke@home”)

………

Call doc.SEND(False, MyRecipients)

Reply | Quote

Brooke,
Thanks, got that. Will try it out. I found the method I used only sent it to the first address of the list…ignoring the others. I appreciate the speedy reply…

Reply | Quote