Access data to Outlook Folder

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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 ‘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 ?

Reply | Quote