PDA

View Full Version : HELP: Find, Filter, copy and then send mail from outlook



rider
04-29-2015, 11:51 PM
Hello Experts,

I have an excel with two worksheets. Sheet1 has the data i need to insert in mail, and sheet2 has the employee name and Ids to find the corresponding data from sheet1.
First, i need to copy the first employee id from sheet2, and then filter using that employee id in sheet1, under column D, then copy from column D to J, with all the rows are visible, and then paste it into an email, send it to the corresponding email id in the sheet2. Also, i need to add a text in the mail "Hello John, please find your allocation as below", where the name john should taken from sheet2, corresponding to the id we copied earlier. I need to repeat this process for all the available ids in sheet2.
I am attaching sample excel. I am using office 2013, with Win 8.1.
I hope its not too much for you guys, Sorry.

Thanks and Regards,
AG.

rider
05-11-2015, 12:15 AM
I found the answer for this, with some trial and error... I had to give up one of the requirements though....

Thanks to all of those who tried helping.

Regards,
AG