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
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,050
Messages
5,569,891
Members
412,298
Latest member
dietitiann
Top