Help me creating Macro which can fetch correct emails

I want to create macro which can give me correct email ids and those i can directly paste in Outlook. I have trades in practice file from trade dispatch file we can identify the emails for those trades with vlookup and in final output i want email ids in proper order in Outlook standard.
Practice file where we have trades
Trade dispatch file where we have email ids