Help! Getting data into excel from outlook using macros

[Al]

Hi there

I'd like to have a macro which will allow you to move the name and email of
a person you receive an email into an excel visual basic form. If I can get
the data into a public variable in excel, I can put it in the form myself,
but how to get to that point?

I managed to get as far as doing something like this :

Set objOutlook = CreateObject("Outlook.Application")
Set objItem = objOutlook.ActiveInspector.CurrentItem
cfullname = objItem.SenderName

but all that gets me is the senders name. I have no idea how to transfer
this to the modules and forms I have in excel, nor how to get the all
important email address.


.....Help!

Al