Create emails in Outlook or Lotus Notes using data from Spreadsheet

Hi Guys,

I'm looking for a way to create e-mails from concatenated values of cells. That concatenated value would be dependent upon whether a check box is clicked or not. (see image - file also attached)

The subject of the e-mail would be taken from the Filename.

In addition, some of the users will be using Lotus Notes and others will be using Outlook, so I need to give the users a choice of which button to press to activate any macros.

Distribution.jpg

Any help you can give me would be greatly appreciated (However, I don't have Lotus Notes to test it on)

Okay Guys,

37 Views and no replies. I've managed to work it out, it's probably not the most elegant way of doing I. But, will try to explain it as best I can. In the attached file several columns are hidden.

In Cell I7 I've put a check box that is linked to Cell I7. When the check box is checked it puts TRUE in the Cell
In Cell D7 I've put an if statement:

Please Login or Register  to view this content.

In Cell J7 I've put a check box that is linked to Cell J7. When the check box is checked it puts TRUE in the Cell
In Cell F7 I've put an if statement:

Please Login or Register  to view this content.

In Cell H7 I've put the delimeter. As it's for Outlook, I've used the semi-colon ";"
In Cell K7 I've pulled the ConcRange Function if Cell D7 is populated

Please Login or Register  to view this content.

In Cell L7 I've pulled the ConcRange Function if Cell F7 is populated

Please Login or Register  to view this content.

I can't work out why it needs D7:E7 or F7:G7 but without it, it doesn't seem to work. I may not need I7 either.

I got the ConcRange Code from elsewhere (wasn't aware of this functionality before) - I can't remember where, and adapted it for my use. but here it is.

Please Login or Register  to view this content.

I then used Cell M1 for the "To" addresses. So, in cell M1 I've put

Please Login or Register  to view this content.

I also used Cell M2 for the "cc" addresses. So, in cell M2 I've put

Please Login or Register  to view this content.

This gave me the List of e-mail addresses, properly formatted (for Outlook) that can be inserted in each field. I'm sure there's a neater way of doing this, so I'm open to suggestions

Finally, I created the macro (linked to the blue button) for MS Outlook to create the e-mail:

Please Login or Register  to view this content.

I have found a macro for doing the same for Lotus Notes but, as I don't have Notes, I don't know if it works. Here it is if anyone wants to test it. I'd be delighted with any adjustments that may make it work.

Please Login or Register  to view this content.

Enjoy and please feel free to provide any feedback.