How to send Lotus email with VBA to more recipients and also to more copy recipients

Hi excel experts, I was looking for some code to be able to send Lotus email with VBA. There were some useful codes (the best I found is below), but I can send email only to one recipient and without copy recipient, so its needs to be utilized, please help. I see in another code example that they are using string for vaRecipient nor Variant, but when I change it, it didn't work !

Please Login or Register  to view this content.

THIS IS THE PART OF CODE I TRIED TO IMPLEMENT BUT WITHOUT SUCCESS, ANY SUGGESTIONS ???

Please Login or Register  to view this content.

THANKS IN ADVANCE FOR YOUR COOPERATION, I THING THAT THIS THREAT (WHEN SOLVED) CAN BE ALSO USEFUL TO OTHER USERS...

You could use an Array to send to multiple recipients if thats what you're looking for.

Please Login or Register  to view this content.

Hi John and thanks for reply, but I don't want to use an array, I want to write the names of recipients into msgbox, and loop until I don't click cancel (like in the second code above).

And also in similar way put the names of copy recipient into msgbox. Please any advice, how to tune the code and get it to work?

Hi xlbiznes and thanks for reply, but could you be more specific because I try it and it don't work for now

Please anyone can you help me with this one because i cant find some useful code to do that, thanks in advance !

Well it dont throw an error, but I am able to put there only one name of recipient and then the code jump to next step. But it should open another msgbox where can I insert more recipient.

I tried to change loop while into loop until, now I can set multiple recipients into msgbox, but after this change email is not send to anybody, please any advice ?

Please Login or Register  to view this content.

Still stuck on this thread, any advice how to finally solve it ? Please help

This is IT !!! You are the man Xlbiznes, really appreciate your help - good job!