Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Extract E-mail Addresses (97 SR2)

    Good Day!

    I would like to write a macro which automatically extracts e-mail addresses from a body of text. Does anyone have any idea how I might persue this? FYI, i'm not great at writing VBA, so examples would be wonderful! ...or perhaps someone has one already written?

    Thanks!

    -K
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extract E-mail Addresses (97 SR2)

    Drk,

    Didi you get any help from <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=72358&page=&view =&sb=&o=&vc=1>this thread</A>?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Extract E-mail Addresses (97 SR2)

    I don't know if Drk got any help from that thread, but I certainly did! I've been looking to try to find a way to extend a found selection back or forward to the next instance of a particular character off and on for ages but could never quite work it out.

    Many thanks, Geoff <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Beryl M


  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Extract E-mail Addresses (97 SR2)

    <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

    Losing more and more of my mind every day... <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

    Thanks for the reminder Geoff..
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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