Macro to find the specific text from the cell content

Hello Guys,

I am using a Macro which copy and paste the sender's name, date, time and email body text from Outlook Inbox into excel columns A, B, C and D.

In second sheet of same excel file I have a person names (for ex: Manish, Ankit, Mohit etc.)

I need help in creating a Macro which can read cell content containing the email text and match if any person name (from second sheet) is present in it.

If present then insert that person name in the adjacent column.

Any help will be appreciated.

Regards,

Maybe:

Please Login or Register  to view this content.

Dear John,

Thanks for reply.

Macro is searching for the “Person Names’ only in first cell of “Outlook Inbox Sheet” of column D.

It has to search into the all rows of column D.

Please help.

Thanks,

Try:

Please Login or Register  to view this content.