Does Sendobject support Pivot table format

[RBPM]

Good afternoon,

Does sendobject support sending a form in pivot table view to excel?

Have a form that is in pivot table view that would like to send to excel in pivot table view and then include it in an email.

If sendobject doesnt support is this doable?

Thanks

 

[psemianonymous]

SendObject supports very basic functions. If you do the "pivoting" inside an Access query, it's possible to send the results of that query out to Excel. Pivot table equivalents in Access are called "Crosstab queries".

It is also possible to do whatever you want with Excel via Office Automation code, but you're probably not willing to invest the time it takes to get this up and running.