doing sums in a table outlook view 
Author Message
 doing sums in a table outlook view

Does someone know (or have had experience about that)
if it is possible to define VBA macros to allow simple mathematics
operation
(in columns or rows) when considering an Outlook view, which is
displayed as a table

(I usually copy-paste the whole view (which is a true table) into MS
Excel, and do my calculation there...

What I wish to have,  is a VBA sample (if available) or directions to
search, to add let's say "column sum" feature, on (for example) a
given selection range (in a column), or, (another example) between two
given dates!

The ultimate purpose is to produce automated reporting sheets, without
having to export all to Excel and do it "manually" each time !

Please help

Kindest regards,

H

--
==============================================================
H DO PHAN                    / Tel Dom: +33(0)1 47 28 83 78

LOOX Software / B&T Engineer  / Website: www.loox.com/fr
=============================================================
Current digital authentication ID:*******8416200010212*******
=============================================================

--
==============================================================
H DO PHAN                    / Tel Dom: +33(0)1 47 28 83 78

LOOX Software / B&T Engineer  / Website: www.loox.com/fr
=============================================================
Current digital authentication ID:*******8416200010212*******
=============================================================



Sun, 23 Mar 2003 03:00:00 GMT  
 doing sums in a table outlook view
Quote:

> Does someone know (or have had experience about that)
> if it is possible to define VBA macros to allow simple mathematics
> operation
> (in columns or rows) when considering an Outlook view, which is
> displayed as a table

The last I heard is that views do not support macros or scripts.  Have
you considered doing this in Digital Dashboard, where you can use an
ActiveX control?

 Hollis D. Paul [MVP - Outlook]


 Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195

 Mukilteo, WA  USA



Sun, 23 Mar 2003 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. calculating sums in a table formated view !

2. Outlook Table View

3. Importing Outlook data into a Word Table - using view control

4. Importing Outlook Data to a Word Table using a view control

5. outlook view control and views/filters

6. Changing the calendar view in a Outlook view control

7. Change view in Outlook View Control (OVC)

8. Customize default outlook Contacts View to display Images in the view

9. Outlook View Control disappears after viewing item

10. Form View/Table View

11. Outlook View Control in Outlook 2002

12. Outlook Object and/or Outlook View Control

 

 
Powered by phpBB® Forum Software