Hi,

Frequently I receive email which contain reference numbers to records in a
database. The references are in the subject or in the body of the email. Now
I select these numbers and copy them, go to another application, paste the
number and lookup the record.
This must be automated, and I know how. But I don't know the VBA code to
capture the selected text/number from the email so I can use this in other
VBA code to open the record in the database.

Is there a way?

Thanks for your help.
René