Re: Sending a Pivot Table by Mail

jerry.ranch@xxxxxxxxxxx wrote in
news:2deaa25dgk74k4pk824acv7ooc017mm0t9@xxxxxxx:

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

Transfer the raw data, then convert to a pivot table in Excel.

Alternative: see if a Crosstab query will do what you want, and
export that instead.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: Sending a Pivot Table by Mail
    ... (which is not possible with the standard crosstab) ... Another option is to export the pivot table to excel from the pivot ... I've tried to send via every format available, ... file of the raw data, ...
    (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)