Help Please

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

benhamj

Thread Starter
Joined
Dec 21, 2010
Messages
3
I am running a pc with Windows XP Pro and Office 03. I have limited experience with Excel. However I have been tasked with creating a spreadsheet to track our consumables in the machine shop. It is my hope to set the spreadsheet to automatically send an email to both my supervisor and myself letting us know the on hand quantity is below a specified value and we need to reorder the part or tooling. I also have a set of spreadsheets I have created for tracking employee production and errors. I would like some information from one to automatically transfer to the other. I will inquire more about this later. I figure I will start with the tracking spreadsheet now and go from there. Attached is the rough spreadsheet I am trying to create. Thank you in advance for your help.
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
I'd love to take a shot at it but that won't be 'til after January 3d. ('11)
For starters, check the different posts where emails can be sent, there are sereval, also where I did some coding.
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
I took a a quick look but your sheet is empty.
You will have to provide at least basic info like when to order, what is the threshhold, etc.

Put some data in to give an idea.

Have you considered MS Access?
 

benhamj

Thread Starter
Joined
Dec 21, 2010
Messages
3
No i haven't thought about MS Access. I Will provide some info to give a basic idea of what I'm looking for.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
benhamj, welcome to the Forum.
As Keebellah suggested Access is far superior for doing what you want, in all three cases. It also has the major advantage that the data can be easily shared by others.
I have posted a few emailing databases quite recently.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top