Possible to input data to generate emails?

tomadams31

New Member
Joined
Apr 7, 2010
Messages
1
Hi,

I am wondering if it would be possible in Excel to get an email automatically sent out whenever a certain data field has been populated?

For instance, I input instrument request data (we work for a partnership that loans them out to schools), and require my manager's approval of such data before I can get the instruments sent out. Rather than having to email her each time I have filled in the new instrument request info, and subsequently having to wait for her to email me back each time she has checked this info and indicated that it is okay to proceed, it would be great if there was some facility that generated a notifying email - both ways - once the dat had been inputted.

Moreover, if the email could contain a link back to the spreadsheet (as well as the notification) this would speed up things even more.

If someone could let me know whether this is at all possible I would be extremely graetful.

Thanks a lot,
Tom
 

arkusM

Well-known Member
Joined
Apr 12, 2007
Messages
560
Hi,

I am wondering if it would be possible in Excel to get an email automatically sent out whenever a certain data field has been populated?

Moreover, if the email could contain a link back to the spreadsheet (as well as the notification) this would speed up things even more.

If someone could let me know whether this is at all possible I would be extremely graetful.

Thanks a lot,
Tom
It is possiable. I am working on something similar but I have to reference Groupwise and not Outlook. But search goolge for various code snippits to get you going. (I use Excel vb* at the begining of all my google search to find code)
 

Forum statistics

Threads
1,082,575
Messages
5,366,412
Members
400,888
Latest member
Cdim7

Some videos you may like

This Week's Hot Topics

Top