Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MAPI OUTLOOK ... (2000 sr 1)

    I dont know if this question go here..?!?

    In other case...

    I get value from GAL in Outlook with macro in module1.
    And it work fine..

    Naturally the operation in macro scan GAL to GAL do until the condtion in

    If Left(LISTA, 5) = "ATM65" Or Left(LISTA, 5) = "ATM45" Then

    is true....

    during the scan the macro cicling 2.600 GAL!!!!!

    but i know the name of gal for my interest ...(range D)

    Is possible to modify the macro and insert in find option "one to one" the value in range D....

    Eaxample

    LISTA=ATM4500 goto

    For Each NOM In LISTA.Members

    Sheets("ATM").Range("A" + RIGA) = Right((LISTA), 4)
    Sheets("ATM").Range("B" + RIGA) = Right(UCase(NOM.Address), 7)
    Sheets("ATM").Range("C" + RIGA) = UCase(NOM)

    RIGA = RIGA + 1

    Next NOM

    finish nom

    go to the next gal in range D

    LISTA=ATM4501 goto

    For Each NOM In LISTA.Members

    Sheets("ATM").Range("A" + RIGA) = Right((LISTA), 4)
    Sheets("ATM").Range("B" + RIGA) = Right(UCase(NOM.Address), 7)
    Sheets("ATM").Range("C" + RIGA) = UCase(NOM)

    RIGA = RIGA + 1

    Next NOM

    ecc...

    LISTA = ATM6552

    ecc...

    finish the cicling

    hope you undestand me:-(

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MAPI OUTLOOK ... (2000 sr 1)

    I'm not sure I understand, but try the attached version. I added explicit declarations and error handling.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MAPI OUTLOOK ... (2000 sr 1)

    No dubt i have understand: my english is very good... <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    You have understand me in "one shot"
    Work perfect

Posting Permissions

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