VBA change a Outlook contact name from last to first to

[dprayner]

Hi people.

I was wondering what the easiest way to change a name returned from Outlook (ie. smith, john) to display the first name then last (ie. John Smith) preferably without the comma.

Than you, DAVE

 

[EBGreen]

If you mean to do it with code then:
strDisplayName = Split(strLastFirstName, ", ")(1) & " " & Split(strLastFirstName, ", ")(0)

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]