Hi I'm banging my head against a brick wall....

I need get the outlook display name into a Excel userform using vba. The problem I have is that nearly everyone won't have put their full name into application properties and therefore when I do get application.username or windows username I get their works number. Whereas everyone must complete their name and the system picks up the office name. I simply need to manipulate the display name as the user who raises the order rather than asking the user to type their own name or select from a pre-populated array.


Dave