1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Outlook VBA - Importing an excel sheet

Discussion in 'Microsoft Mail (Outlook / OE / Windows Mail)' started by _david, 2005/07/18.

Thread Status:
Not open for further replies.
  1. 2005/07/18
    _david

    _david Inactive Thread Starter

    Joined:
    2004/10/05
    Messages:
    18
    Likes Received:
    0
    Does anyone know how to import a contact database with VBA into an outlook folder? The database is a tab-delimted file from excel.

    _david :confused:
     
    _david,
    #1
  2. 2005/07/18
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,314
    Likes Received:
    252
    Which version of Outlook?

    Have you tried Outlooks Import function?
     
    Steve R Jones,
    #2


  3. to hide this advert.

  4. 2005/07/18
    _david

    _david Inactive Thread Starter

    Joined:
    2004/10/05
    Messages:
    18
    Likes Received:
    0
    Alot of different files

    I've got alot of excels sheets (like over 1000) to import. Outlook 2003, I'm trying to create a VBA script to read a bunch of files in a single directory and then change directories and load the excel sheets there, etc..

    Also, I'm trying to create a program that move's the mouse and presses the button automatically to create scripts that way. Do you know where I can start looking for pointer-x,y set and stuff for that?

    _david
     
    _david,
    #3
  5. 2005/07/18
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,314
    Likes Received:
    252
    How many contacts are in each of the spreadsheets?

    I've never done anything close to what you are attempting BUT would think getting all the contacts into one speadsheet would be worth considering.
     
    Steve R Jones,
    #4
  6. 2005/07/18
    _david

    _david Inactive Thread Starter

    Joined:
    2004/10/05
    Messages:
    18
    Likes Received:
    0
    Alot of different files

    I've got alot of excels sheets (like over 1000) to import. Outlook 2003, I'm trying to create a VBA script to read a bunch of files in a single directory and then change directories and load the excel sheets there, etc..

    Also, I'm trying to create a program that move's the mouse and presses the button automatically to create scripts that way. Do you know where I can start looking for pointer-x,y set and stuff for that?

    _david :eek:
     
    _david,
    #5
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...