Outlook to excel vba macro code

[Dougmorgan]

Hi Forum,

I have a folder containing 2500 emails which all contain the same information.
I am looking for some vba code to extract this information. I'm new to VBA so would really appreciate some help.

This is what is in all the emails.

NAME: David smith
POSTCODE: ABC 123
E:MAIL ADDRESS: (e-mail address removed)
TELEPHONE: 01234 56789
CAMERA CLUB/PHOTO SOCIETY/FEDERATION: Toytown