Send email to many recipients using Excel...almost

I feel like I almost have the Excel button I need (thanks to an exhaustive forum search), but I have 2 problems that I need help to correct. First, the code works fine if I have one email address in my Email column, but If I add a second or third email in my column, the code sends the mail, but bounces back because of an Invalid Internet address specified error. The response looks to me like it is taking the first address and appending to the second email recipient. An example would be <example@example.com,example>@example.com.


Here is the code I am using:

Please Login or Register  to view this content.

I would also like to view the email before it is Sent. Thanks in advance for the help.

I am almost there, but could someone help me with one final problem...
The code below creates an email in Lotus based on emails in a column, I would like to be able to edit the Body and Attachments before the email is sent. As the code stands, it automatically sends the email when I click the send Email Button.

Please Login or Register  to view this content.