View Single Post
  #2  
Old June 28th 06, 07:10 AM posted to microsoft.public.outlook.contacts
IvKo
external usenet poster
 
Posts: 23
Default Export to Excel, then to Visio (Org Charts)

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.




"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