RunCommand acCmdExport Help

[Charles Rossi]

A user wants to export an address book into any one of the choices that the
export wizard offers. I have a query that runs that selects the fields for
export. It has to be seamless from a forms window. I've tried the OutputTo
command, but its limited to just a few file types. That goes for the
"transfer" commands as well.

I am trying to use RunCommand.acCmdExport, but it doesn't allow passing of
data to it. I've put a RunCommand.SelectObject first, but that wants to
open the database window first on top of the forms before running the
export.

Any help would be appreciated. Thanks.

 

[Jeff Boyce]

Charles

Take a look at the SendObject method.

 

[Charles Rossi]

I was under the impression that SendObject is to send a file/report to an
email recipient. And it only supports basic file types, not all that are
included in an export wizard.

 

[Jeff Boyce]

Ah, my bad!

Jeff Boyce
<Office/Access MVP>

I was under the impression that SendObject is to send a file/report to an
email recipient. And it only supports basic file types, not all that are
included in an export wizard.