View Single Post
  #3  
Old July 20th 06, 12:59 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Export to Excel, then to Visio (Org Charts)

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Lamichael" wrote in message ...
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


Ads