Use an array in excel 2007 to send email via lotus notes to multiple recipients

Hello,

I need some assistance in making VBA recognize an array, being parsed with a comma-deliminated value, as a string and then sending that array as the .sendto in my email. I can make this work with a single email address entry all day long but I need to have a multiple receipient email based on user input. I have commented out my array below. Any assistance would be greatly appreciated.

Please Login or Register  to view this content.

---------- Post added at 03:32 PM ---------- Previous post was at 03:25 PM ----------

I thought I posed an update referring to the error itself but after several page refreshes, it is not appearing. So I will try again. My issue is a "Type Mismatch" on the line [ ArSendMeAway = (LResponse & ",") ]. I am trying to get it to accept and allow the "," as part of the array so it can be placed in the .SendTo portion and therefore the To field in lotus.

With the SendTo email addresses in a comma-separated string, use the Split function to pass them as an array to the Lotus SendTo property, like this:

Please Login or Register  to view this content.

This just shows the essentials to hopefully solve your problem; I'm sure you can adapt it for your own code.