Export to Excel, then to Visio (Org Charts)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lamichael - 28 Jun 2006 02:26 GMT

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

Reply to this Message

IvKo - 28 Jun 2006 06:10 GMT

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.

> 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.
[quoted text clipped - 12 lines]
>
> Name FirstName1 LastName1 JobTitle

ManagersName1

> WhitacreEd Ed Whitacre President & CEO
> CicconiJames James Cicconi VP Ed
[quoted text clipped - 3 lines]
> Thanks,
> Lamichael

Reply to this Message

Sue Mosher [MVP-Outlook] - 19 Jul 2006 23:59 GMT

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

Signature

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

>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.
[quoted text clipped - 19 lines]
> Thanks,
> Lamichael

Reply to this Message