G
Guest
I frequently move "Contacts" data from Access to Outlook using the import
command. Can this be automated using a VBA "import" command?
Or, put another way, obviously the process itself can obviously be automated
using VBA. But, all the sample code I've seen to do this involves writing
loops that go through the Access database involved one record and one field
at a time and write that record's fields to Outlook's contacts folder. It
would be much simpler for me if I could just write a macro that reproduced
the effect of the following commands in Outlook:
File | Import and Export | Import from another file or program | Microsoft
Access -- etc.
Is this possible? Does such a command exist?
command. Can this be automated using a VBA "import" command?
Or, put another way, obviously the process itself can obviously be automated
using VBA. But, all the sample code I've seen to do this involves writing
loops that go through the Access database involved one record and one field
at a time and write that record's fields to Outlook's contacts folder. It
would be much simpler for me if I could just write a macro that reproduced
the effect of the following commands in Outlook:
File | Import and Export | Import from another file or program | Microsoft
Access -- etc.
Is this possible? Does such a command exist?