Unfortunately the Import/Export Wizard cannot be automated. Based on the
things you need to do, it's probably best to build a custom import process
anyway.
--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog:
http://blogs.officezealot.com/legault/
" wrote:
Thanks for the suggestion. I have used it personally but the process
that is in place is automated and I can not find how to programatically
manipulate the import/export wizard. From the end-users point of view,
this process is 1) pull in flat file from web 2) open Access database
and wait 3) send emails. The wizard requires that the users know which
address book to use and opens up the possibility that the import will
be put in the wrong place. Also, the code does do some data validation
that the wizard would not know anything about; business logic mostly.
Now, if there is a VB or VBA object that can use the import/export in
Outlook, that would be great. Something like the DoCmd.TransferText
statement does in Access.
-dt