Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export ACTUAL E-mail, not exchange version (Outlook 2003, Win 2K Pro)

    I suspect there's a config issue but I have tried exporting a contact file via Excel, CSV and Access, with mapped fields to include all varients of "Email" and still - Bill Gates refuses to give me something non-proprietary. All exports to file give me this format for an e-mail:

    /o=HHSC/ou=MAIN/cn=Recipients/cn=dabney EX Abney,Dorothy

    This is extremely un-helpful. How do I get Bill to do what I want, which is you@email.com rather than Bill's preferred Exchange type of address?

    TIA

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    I expect these are X.400/X.500 addresses on your mailserver which you have imported from a Global Address List or such. Oddly, I used to have that problem, but with Outlook 2003 and Exchange 2003 if I import GAL listings to contacts I get the SMTP address.

    You can use a macro transform in Excel, like the core of <!post=this one,569,146>this one<!/post>, which I do NOT recommend you run in Outlook, for the reasons I note in the Post.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    <font color=red>PROBLEM SOLVED - NO THANKS TO OUTLOOK</font color=red>

    This handy tip works: http://www.contactslive.net/ResourceCenter...Files.aspx#SMTP. You can setup the Phone list with just the data you need. Don't get fancy or the paste into Excel may have spurious rows apparently caused by hidden carraige returns. Probably a way to defend against it but blah it's late.

    <------------------------------------------->

    thanks for the insight - not very helpful, tho. yes, the import is from the GAL.... not sure why that is such a big problem.

    I am VERY frustrated when I look at a contact and it clearly displays the SMTP address. I even tried importing using Feddema custom Outlook to Access and it simply refuses to pick up the mysterious, "I'm here but you can't find me" field in the Contact form. Can't seem to specify it in any way. And a conversion routine isn't attractive as i KNOW the damned info is there, somewhere...unless it isn't, and is just pretending to exist.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    Did I imply my reply would be helpful? <img src=/S/grin.gif border=0 alt=grin width=15 height=15> To be even less helpful, the SMTP is in the GAL all right - see my censored corporate listing attached.

    Have you looked at the all the Contact EmailAddress properties in the VBE? It may be that they don't export as SMPT in the default export Wizard, but you could write an export-to -Excel macro.
    Attached Images Attached Images
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    Good find, thanks.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    Yeah I've seen the SMTP acting all innocent and available in the GAL. Strange, IMHO, that standard export simply does not get it. Even attempting a VBA solution (which may have been malformed from my end) failed to find the field in the standard Contacts form "Email". So, OK, the issue has been solved but I wonder why Bill made it so hard to do? Does MS hate SMTP and want the world to use X.400/X.500?? weird.

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    Looks to me like the problem is that Contacts created from the GAL use the X.400 address, not the SMTP address; the export just exports whatever the heck it finds.
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Super Moderator
    Join Date
    Dec 2000
    Location
    Renton, Washington, USA
    Posts
    12,560
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    This has been do in this manner because most companies did NOT want their "address book" copied and used for personal use.

    How did you get a "GAL" listing if not from exchamge?

    Now running HP Pavilion a6528p, with Win7 64 Bit OS.

  9. #9
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,573
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    FYI, in Outlook 2007 if you select the Contacts you want to export, right click and select Send Full Contact | In Internet format then Outlook will open a new email message with the contacts as vCard attachments. Then you can save or email the attachments.

    Joe
    Joe

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export ACTUAL E-mail, not exchange version (Ou

    This makes the most sense in terms of the amount of difficulty involved in getting the, otherwise clearly displayed, SMTP address from a GAL using Exchange. In my case I needed the SMTP addresses for a legitimate business use, which is to load e-mail addresses in a separate system intended for special mailouts. But I can see the logic here and, from a systems perspective, having more than one way to e-mail can certainly be a problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •