Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access data to Outlook Folder

    Does anybody know how i can create an item in a public folder through VBA? I have written a process to gather information from an Access database and create a contact item but i have to create the item in my own contacts folder and then move it to the desired public folder. Surely there is a way of creating it in the public folder directly? I have full control of the public folder - i created it ! Would it be quicker to create all items and then move a whole folder ? there are approx 1400 contacts after the process is complete.

  2. #2
    New Lounger
    Join Date
    Feb 2003
    Location
    Charlotte, North Carolina, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access data to Outlook Folder

    Check out q208232 OL2000: How to Programmatically Import Items from Access in the MS Knowledge base

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access data to Outlook Folder

    This is what i have, although my code is a little different, but where they have the lines:
    c.save 'save the item

    .movenext 'move to next item in db
    I have:
    c.save 'save the item
    c.move <mypublicfolder> 'move the item to mypublicfolder
    .movenext 'move to next item in db

    i want to save the item in the publicfolder straight away because it seems to cause problems with my outlook client.
    any more ideas anyone ?

Posting Permissions

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