Share Utility Records?

85 pts.
Tags:
Data management and storage
Excel worksheets
Microsoft Excel
I maintain utility records for several different buildings. I would like to share individual records with their supervisor. Presently, the records are stored on one excel page. I can't seem to divide up that one page into an email for each account. What would be the best program to use to store individual building stats and then email them to each supervisor?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Personally I always prefer using databases rather than Excel so you might consider to import your data into SQL tables and then from there by querying the data you can use many techniques to send these data to the given targets. Example you may use VBScript to extract the data and sends them via email or you may use a SQL Agent Job with DB mail and so on.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SbElectric
    ITKE has correctly mentioned that a database provides many more options than an excel spreadsheet. But if you are in a hurry & not familiar with database - then you may consider a few “quick and dirty” options. 1) Can you add a column to designate various buildings (Category)? All Records for Building ABC will be 1; all records for building DEF will be 2, etc. Now you can sort the spreadsheet based on this category column. You can then add page breaks (or filter) to suit your needs. May produce a .pdf copy on filtered data – which may be e-mailed. 2) If the number of buildings are reasonable – (less than say 20) then you may be able to create individual worksheets for each building. You can still create a summary total of all buildings – by summing (or averaging) individual worksheets. Again database (Oracle, SQL, Access) will provide many options -- long-term stability, growth, better security, better reporting, etc. Good luck.
    2,540 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following