Is there a way to import Outlook e-mails through VBA? Even if it's not completely automated where it would atlease open up the Outlook Folder import wizard where the user can select the account they want to import in, that would work as well. I cannot find anything on this for some reason.

Any assistance would be appreciated.

Hi Dan,

Do you mean something like this?

DoCmd.RunCommand acCmdImportAttachOutlook

Hope that helps...

That works. That's all I needed. Thanks. Is there a way to automate that though? I know theres ways to do it but it goes to the default inbox and I would need it to go the a number of different accounts. I was just curious if that is possible but what you supplied me will work for sure.

Hi Dan,

If you want to automate the process of selecting a mailbox, you'll have to resort to Outlook Automation.

Hope that helps...

Thanks. I was afraid of that. I think that would over complicate it. I'm doing this for a client remotely, so that would involve a lot on their part as well as far as explaining how to place the modules etc.

Yes. I can see how that could be painful. (IMG:style_emoticons/default/crazy.gif)