Sending a Pivot Table by Mail

I have a series of macros that send various queries as xls files to
clients. The scheduling of the sending is done by calling the macro
from the Windows Task Scheduler

All work great, except sending a pivot table.
I've tried to send via every format available, and I cannot get Access
to send the format as it is displayed on the screen..I just get an xls
file of the raw data, not the pivoted data

Is there a way to do this please?
Thanks
Jerry




.

Relevant Pages

  • Re: DNS Alias
    ... a lot of *.xls files are stored on this machine. ... these macros and links hard coded "filesrv1" within them. ... Windows Server 2003-based computer may not work with an alias name: ...
    (microsoft.public.windows.server.dns)
  • Excel / XP SP2 / Web
    ... the XLS files contain macros that are executed when the XLS file is opened. ... disabling macros. ... If I choose to execute the ...
    (microsoft.public.excel.programming)
  • Re: Macro locks me in a single XLS file
    ... i am not running two macros at the same time... ... The buttons are the the buttons on the taskbar (where every program has ... When you run two XLS files they are shown in the taskbar as two ... separated programs. ...
    (microsoft.public.excel.programming)
  • Re: Running Macros
    ... Are you Macros who posted a very similar question? ... Then use a windows scheduling program (either the one built into newer(?) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Scheduling Macros to Run
    ... Maybe you could just use a macro named Auto_open (in a general module) to kick ... off your macros that should be run. ... Then use a windows scheduling program ...
    (microsoft.public.excel.misc)