Ask Experts Questions for FREE Help !
Ask
    aaron7878's Avatar
    aaron7878 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 12, 2007, 08:57 AM
    Email from exel
    I have an inventory spreadsheet with 6 columns. I need a formula that will email me when the value of a cell drops below a set point. I.e. if E5 = <3 then email contents of E1, E2, E3, E4, E5 & E6 to mailaddress. Can this be done?
    asterisk_man's Avatar
    asterisk_man Posts: 476, Reputation: 32
    Full Member
    		  
    #2

    Mar 12, 2007, 09:54 AM
    Write some VBA code.
    Use the worksheet's calculate sub and call the SendMail function.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Email [ 3 Answers ]

Sunday Morning: A user leaves a voicemail at 08:00. At 10:00 they email the Helpdesk and complain that the voicemail has not been addressed. The voicemail system will be unavailable, due to scheduled maintenance, from 08:00 - 12:00. You attempt to call the user, but they are working from home (we...

Email Our troops and be email pen pals [ 6 Answers ]

Does anyone know how we can email our women and men serving our country. I think it would be great to have overseas pen pals. To be able to talk to them, and let them know we support them . And give the other people to talk to state side.

Email [ 2 Answers ]

How do I send a song to another email address?

Sent Email [ 7 Answers ]

Is there a way that I can get notification that an email has been read? Thanks

View more questions Search