One email using contents from multiple cells using Lotus Notes

Hi tommytee ... try this:

Please Login or Register  to view this content.

And your email sending module becomes:

Please Login or Register  to view this content.

Hope that helps. MM.

Hi Tom - I'll try to address your questions individually:

You've said the contract name is in Col D, contract mgr in Col H and the contract mgr's email in Col I.

The contract name that I assumed to be in Col A just needs to be changed from 1 to 4 (A to D):

Please Login or Register  to view this content.

The contract mgr's name is in H (col 8) and the email address in I (col 9) - I had assumed you were using only the name since Lotus would resolve that name into an email address based on your global address book, but it's better that they're separate, so:

Please Login or Register  to view this content.

I've adjusted the code to cope with this and stored both the name and email in arrays. I've also created explicit column definitions that you can amend right at the top of the column; if your email column changes, just change the initialisation section accordingly and it will run fine. I originally had this looking in column 5 (E) because you had 5 hard-coded, but I've now changed that as well.

For your other question about how to activate it, I suggest you set up a button on the worksheet labelled something like "Send Email Notification to Selected Managers". Right click on it, select "View Code" and this will create an OnClick event for the button. Just call the control module from this ... I've done this for you and it's in the attached file (just click on it and drag it to wherever you want it on the sheet). When you click the button, the code will automatically send an email to each manager that has "a" in the 2nd column.

Here's the full code; and also in the attachment.
In the "Current" sheet object:

Please Login or Register  to view this content.

In the workbook object - build module:

Please Login or Register  to view this content.

In the workbook object - send module:

Please Login or Register  to view this content.

Hope that helps.