Re: Export address format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Use the Recipients collection, not the Bcc or Cc fields, which return only display names (which is only sometimes the same as the address, depending on how the sender entered the recipient).

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


"Bob Inwater" <BobInwater@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:932365E8-292F-4E5B-9A1C-40BFBCAE65F3@xxxxxxxxxxxxxxxx
>I recently wrote a Macro that went though my inbox and exported every
> objMailItem.SenderEmailAddress to Excel. This allows me to capture a master
> email list. With the SenderEmailAddress code my export gets the address in
> the SuchAndSuch@xxxxxxxxxxx format. My issue now is that in the bcc or cc
> fields I often get the intended recipients alias as in“ Joe Schmo” but not
> his address as in Joe@xxxxxxxxxx (I assume that the one format is an object
> of the other or something of the sort.)
>
> I am perfectly happy to give up on doing this in vba. When I cut the
> addresses that read something like “Schmo, Joe <Joe@xxxxxxxxx”. > from the
> cc or bcc field and paste anythere outside an Outlook address field I lose
> the Joe@xxxxxxxxx format and only get the Schmo, Joe.
>
> Ideas? I am using Outlook 2003 to get the objMailItem.SenderEmailAddress to
> work….
>
.

Relevant Pages

  • Re: Hiding Contacts info from Contact when group emailing
    ... I presume that you mean Outlook Express version 6. ... Mailing List" entry and in the BCC field select the "Bob's Mailing List ... Recipients will see "Bob's Mailing List" in the TO field ... composition window in order to see the BCC field.) ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: [PHP] Sending lots of emails - 2 choices - choose the best one
    ... Write a subroutine that would group recipients based on host, and send one mail to each host with bcc. ... Also I would not use the internal mail function, instead I would try a full smtp class, especially when using mime that has built in support for services such as hotmail, yahoo, etc. ... Whenever we send email list to hotmail users I format the message differently then when we send to yahoo, ...
    (php.general)
  • Re: blocked as spam
    ... from Outlook or from a Word merge to Outlook. ... "Peter Jamieson" wrote: ... However, you could be merging to HTML format or plain text format, or ... If the recipients are complaining about the omission then it is up to ...
    (microsoft.public.word.mailmerge.fields)
  • Re: blocked as spam
    ... from Outlook or from a Word merge to Outlook. ... a SPAM engine, unless they are somehow picking up on the fact that you ... However, you could be merging to HTML format or plain text format, or ... If the recipients are complaining about the omission then it is up to ...
    (microsoft.public.word.mailmerge.fields)
  • Re: sending multiple emails
    ... number of recipients that I could send an email to, ... Is that a Outlook code or a RoadRunner code? ... > My son sends out a newsletter to 200+ through Word, I don't know the details; ... >> When using the BCC feature will the recipient's email server translate my ...
    (microsoft.public.publisher)