Export to Excel, then to Visio (Org Charts)

[Guest]

I am trying to export my database to into Visio so I can automatically create
org charts. I am having a problem with the names.

If I have a contact named John Smith, Outlook exports the name as SmithJohn
in the name field. That is what Visio keys off of (manager name) to figure
out how to organize the org charts. I am trying to figure out how to export
the name normally. I have changed the file as setting and it does not do
anything.

If I go in the file and manually change the name to John Smith, the org
charts work perfectly.

Anyone have any ideas?
Below is an excerpt from my file.

Name FirstName1 LastName1 JobTitle ManagersName1
WhitacreEd Ed Whitacre President & CEO
CicconiJames James Cicconi VP Ed
Whitacre
StephensonRandall Randall Stephenson COO Ed Whitacre

Thanks,
Lamichael

 

[IvKo]

Try

http://www.imibo.com/imidev/Exchange/imice.htm

IMI Contacts Exporter for Microsoft Exchange Server is specially designed
for Microsoft Outlook users to export Contacts from any Outlook and/or
Exchange Public Contacts Folder (or private Mailbox folder) to MS Access
2000 table or MS Excel file.

 

[Sue Mosher [MVP-Outlook]]

It might be as simple as changing the field mapping for the export.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers