Select Text in an email and that selected text should be copied automatically

[vbmalik12345]

Hi All,

I'm quite new to the macro. I receive lot of emails as part of my work. We need to create a list of actions based on that emails. So currently we select the text we want to copy, right click or ctrl +c and then create an action log.

Copying this manually using right click or Ctrl+C and then paste to an action log is very tedious.

So im looking for a macro, which can copy the selected text from the email body and copy into an excel sheet.

Could someone help.

Regards
vbamalik

[gmayor]

What is it that you are copying and where in the sheet is it being copied to?

[vbmalik12345]

What is it that you are copying and where in the sheet is it being copied to?

These are different actions & issues reported by my team and i want this to get copied into excel sheet.

[gmayor]

Given that we haven't seen your e-mails and you haven't said what you want to extract from them, and we don't know how your Excel sheet is formatted and where in it those pieces of informatioin are to be copied, it is rather difficult to suggest how you might do it. VBA requires some certainty in order to reproduce the tasks required.

https://www.gmayor.com/extract_data_from_email.htm explains how to extract data from messages.