Email through Lotus Notes Multiple Recipients

[yawnzzzz]

I have a macro that will send part of a workbook to a specific recipient. Works great when there's one person who needs to receive the document. When there's multiple, I can't seem to get it to work. Using commas or semicolons to separate email addresses does not appear to work. Any ideas?

Please Login or Register  to view this content.

[Kenneth Hobson]

You can parse it and pass as an array or pass the comma-delimited string as I did and parse it to an array as I did in this example.

Please Login or Register  to view this content.

[Jimmy0306]

Yawnzzz,
You may want to check out my code by searching for Create Lotus Notes Draft email from filtered or unfiltered List. It creates a single email to many recipients. It can use filtered or unfiltered lists. The only prerequisite is that you have a workbook set up with Sheet1 and Sheet2. The column labels are in Row4 and the email addresses start in Row 5 in Column G

I have a button on my sheet that calls CheckForAutoFilters and all code is pasted in Module1 (not that the names matter). You can change the routine as you see fit.