Choose particular values from a column using dialogue box and copy contents to email?

Hello,

I would like to select certain values from a column (find the column using dynamic search) and be able to select only the required values and paste in email.

Below are the steps i will be processing

1. Use a dialogue box to choose required values from a particular column
2. Copy only the required rows and columns based on the selection
3. Paste the copied data to outlook email
4. Extract "To" and "Cc" from the selected data.

Any help on this regard would be highly appreciated!

Could you attach a sample file so we can see what your data looks like?
Also need some more info about the search criteria. Is it one value or multiple values for the criteria?

BSB

Sample.xlsm

Here is the scenario im working with

On the search criteria, i am working with multiple values from the same column.
So, if my column has 15 values, i need a dropdown of the unique values for me to choose which ones need to go inside the body of the email.

And which columns from the data need to go in the email?

BSB

BSB,

Buddy any luck with the code? Sorry, i am banking on the solution to complete my task.

Thanks a lot for pitching in bakerman2.

Can you pls copy and paste the code in the window here? I am unable to view the code due to security settings at my work laptop. I tried copying the code, but it shows an error to run macros. Sorry for the trouble and thanks a lot for the help. Appreciate it!

Hey thanks a lot for the response. I am encountering some issues as below.

1. The project name chosen gets pasted in Output sheet, K2, any reason why?
2. I am unable to copy the range. It throws an error stating, "The extract range has a missing or invalid field name"

Because of this error, i am unable to run the complete macro.