Hi everyone!

I know the solution for this is given in the solutions. But my problem is bit diffrerent.
I have a gui It contains following components.

1. Select Worksheet to email(All he sheets comes in a listbox we can select any on of it.)

2. Select recipeient to whom u want to mail (I am getting the list from outlook contacts, But i am getting it in this form---- lastname,firstname----)


3.Enter message for the body


4. Enter subject

5. Send worksheet



Now i want to send the selected worksheet to the recipient in the textbox,In text box i dont have his/her email id so i have to take it from outlook by matching the name and lastname.

can u give me the solution