A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Export to Excel, then to Visio (Org Charts)



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 28th 06, 03:26 AM posted to microsoft.public.outlook.contacts
Lamichael
external usenet poster
 
Posts: 1
Default Export to Excel, then to Visio (Org Charts)

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
  #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




  #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


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I export a distribution list to excel? [email protected] Outlook - General Queries 3 May 24th 06 02:35 AM
How to export distribution list to excel will~ Outlook - Using Contacts 2 May 4th 06 04:48 PM
Can I export a Global Address List to Excel? Josh Craig Outlook - Using Contacts 2 March 14th 06 02:30 PM
Export Excel to Outlook Contacts Kerri Outlook - Using Contacts 1 March 8th 06 09:43 PM
Since installing Visio 2003, I do not get any Outlook journal trueblueroo Outlook - Installation 0 January 9th 06 06:00 PM


All times are GMT +1. The time now is 03:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.