Can I sum a field that appears in every record of address book?

[ShellBell]

Hello...

I've designed a custom form that includes several currency fields such as
TOTAL BILLINGS and TOTAL PAYMENTS... Can you please advise and/or direct me
to the method/procedure to allow me to somehow total these fields for all of
the contacts in an address book?

Running Outlook 2003 on SBS Server 2003...the address book is located in a
public folder.

Thank You.

 

[Sue Mosher [MVP-Outlook]]

You would need to iterate all the items in the folder and generate a running total. Your message isn't clear, though, on where you want this information to appear.

 

[ShellBell]

Thank you very much for your response. I would be looking to have this
"total" appear in an outlook view or report of some type. To clarify the
scenario, I have created custom forms which calculate the balance currently
due for each construction job in process...along with various other contract
details. I want to be able to provide my boss with a method to have this
field, and others, totalled. Right now, I have a view which details this
field and others....but no total at the bottom.

Please forgive the awkwardness of my questions, I am completely new to
programming in outlook...but have found the information on this board to be
very helpful.

I somewhat understand your response...can you please direct me to best
method to iterate?

Thanks in advance for your assistance...

 

[Sue Mosher [MVP-Outlook]]

An Outlook view can show only the items in the Outlook folder that you are viewing. Therefore, you'd need to be thinking about a "report of some type." It could be in Excel, in Word, or in just a simple message box that pops up.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers