Re: Sending a Pivot Table by Mail

Try a crosstab as suggested or if you have multiple column headings
(which is not possible with the standard crosstab) you could try a
utility like MegaCrosstab. www.megacrosstab.com .I dont want to spam
the group, but it is something that would solve your problem.

Another option is to export the pivot table to excel from the pivot
table toolbar and send the excel pivot table via mail.

AP

jerry.ranch@xxxxxxxxxxx wrote:
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: Sending a Pivot Table by Mail
    ... calling the macro from the Windows Task Scheduler ... I've tried to send via every format available, ... Transfer the raw data, then convert to a pivot table in Excel. ...
    (comp.databases.ms-access)
  • Pivot Table Grouping by Month
    ... In my raw data, I have field called Month and it's entered as 4/1/05 ... but formatted as April-05. ... pivot table, ... as April-05 without having to format each individual cell in the pivot ...
    (microsoft.public.excel)
  • Re: Pivot Table Grouping by Month
    ... doesn't format it very well, or copy the range into another column, format ... > In my raw data, I have field called Month and it's entered as 4/1/05 ... > but formatted as April-05. ... > pivot table, ...
    (microsoft.public.excel)
  • Re: Problem formatting pivot table headers
    ... Ensure "Auto format table" is unchecked in pivot table options but "perserve ... enable selection should be turned on. ... From the Pivot toolbar, choose PivotTable>Select ... column headers did not inherit the propper cell background colors. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: pivot table formatting
    ... Position your mouse over the row of the pivot table that has all your ... "titles" for each column and format all those headers to bold. ... if you really want to avoid the end user having to "refresh" the ... worksheet tab and select "View Code", ...
    (microsoft.public.excel)