Add ListBox Column values to Email To: field

[AndyEd]

In the attached Workbook I have a couple of ComboBoxes which a user will use to select a contact to email. The selections will appear in a ListBox below the ComboBoxes.

The ListBox has 2 Columns - The 1st contains the contact Name; The 2nd their Email address.

When the user clicks to send the email I would like to have the email addresses in the ListBox populate the To: field of the email.

I have managed to get as far as passing Col1 Row1 from the ListBox over, but can't figure out how to pass the subsequent Row2... etc value over. I'm also not sure how to select the 2nd Column, hence at the moment I'm getting the contact Name rather than their Email - yes I could simply put the email address in Col1, and even their name in Col2, but I think it looks neater with their name appearing first.

Would anyone be able to assist.

Many thanks in advance.

[BadlySpelledBuoy]

Try adding the bits in red below to your existing code.

Please Login or Register  to view this content.

BSB

[AndyEd]

Brilliant! Thank you.

[BadlySpelledBuoy]

Glad I could help

BSB